Tips for Simplifying Crosstab Query Statements

Rob Gravelle takes a complex SQL statement and shows you several ways to re-write it that both simplifies and shortens it, while still yielding the same results.

What is this?

SELECT setter

Curiouse View to create for SQLServer 2005

Forecasting with SQL

Can you use SQL Server to extrapolate out trends from your data? Lots of companies would have you buy a BI solution instead, but new author Mark Wojciechowicz brings us a great example of how you could forecast something in T-SQL.

NULL & 'NULL'

usp_TransposeNRows v2.0

Transpose N rows of a table (v2.0 allows user to specify the table's schema)

Rowcount

Bit by bit

Query cost