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.

Cleaning Up Garbage from Data

Cleaning up garbage from data can be a big problem for a developer.Check out a simple solution from Shubhajyoti Ghosh to cleaning up garbage from data.

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