Randomizing Result Sets with NEWID

Seth Delconte brings us a technique to solve a common request. Using the NEWID function to return a random record from a result set.

Numeric or Not Numeric

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)