More TSQL Analytic Functions – PERCENT_RANK
Percent rank is defined as the number of values that are the same or less than the current value divided by one less than the… Read More »More TSQL Analytic Functions – PERCENT_RANK
REVENUE
Using the TSQL CASE Statement
Here is a quick video tutorial on how to use the T-SQL CASE function on SQL Server 2012, SQL Server 2014 0r newer. This was originally… Read More »Using the TSQL CASE Statement
Using the TSQL IIF Function
Here is a quick video tutorial on how to use the IIF function on SQL Server 2012, SQL Server 2014 0r newer. This was originally part… Read More »Using the TSQL IIF Function
TSQL Queries – Using NTILE
NTILE is a SQL Server function that can be called in a TSQL Query. This is part of the free sql query training to prepare… Read More »TSQL Queries – Using NTILE
Rows and Range, Preceding and Following
SQL Server 2012 adds many new features to Transact SQL (T-SQL). One of my favorites is the Rows and Range enhancements to the over clause.… Read More »Rows and Range, Preceding and Following
SQL Server 2012 IIF Statement
SQL Server 2012 introduces the IIF statement. It is very similar to the IIF statement in MS Access. I have extracted the IIF part of… Read More »SQL Server 2012 IIF Statement
IIF in TRANSACT SQL on SQL SERVER 2012
For years I have heard the question of how can I do an IIF in TSQL? Honestly I never thought it would be that useful… Read More »IIF in TRANSACT SQL on SQL SERVER 2012
More TSQL 2012 Analytics CUME_DIST – Cumulative Distribution
Continuing on the TSQL 2012 Analytic Series now on to the CUME_DIST function SQL Server 2012 introduces another new analytic function. The Cumulative Distribution Function… Read More »More TSQL 2012 Analytics CUME_DIST – Cumulative Distribution
More TSQL Analytic Functions – PERCENT_RANK
Percent rank is defined as the number of values that are the same or less than the current value divided by one less than the… Read More »More TSQL Analytic Functions – PERCENT_RANK
TSQL Analytic Functions LEAD and LAG
SQL Server 2012 introduces 8 new analytic functions. This post will cover 2 of them LEAD and LAG, which can be used to reference a… Read More »TSQL Analytic Functions LEAD and LAG