How to convert a number to a comma-formatted string?

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/03/03/how-to-convert-a-number-to-a-comma-formatted-string.aspx

TSQL Challenge 1

Moved to http://beyondrelational.com/tc/challenge1

How to write a query to filter rows against a parameter list

Moved to http://beyondrelational.com/blogs/jacob/archive/2009/01/18/how-to-write-a-query-to-filter-rows-against-a-parameter-list.aspx

How to find the amount of space used by data (.mdf, .ndf) and log (.ldf) files using TSQL

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/10/17/how-to-find-the-amount-of-space-used-by-data-mdf-ndf-and-log-ldf-files-using-tsql.aspx

UNPIVOT Example 2

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/10/11/another-unpivot-example.aspx

TSQL Lab 20 - Performing recursive updates using a BOTTOM to TOP recursive CTE

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/10/02/tsql-lab-20-performing-recursive-updates-using-a-bottom-to-top-recursive-cte.aspx

TSQL Lab 19 - How to find differences between two dates in HH:MM:SS format?

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/10/02/how-to-find-differences-between-two-dates-in-hh-mm-ss-format.aspx

TSQL Lab 18 - Performing Recursive Updates using CTE

moved to http://beyondrelational.com/blogs/jacob/archive/2008/10/01/tsql-lab-18-performing-recursive-updates-using-cte.aspx

TSQL Lab 17 - An example using UNPIVOT (Transforming Columns to Rows)

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/09/29/an-example-using-unpivot-transforming-columns-to-rows.aspx

TSQL Lab 15 - Another PIVOT Query Example

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/09/29/another-pivot-query-example.aspx

Be careful when renaming SPs/Views/Functions/Triggers

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/09/28/be-careful-when-renaming-sps-views-functions-triggers.aspx

TSQL Lab 14 - Performing a recursive update for more than 32 levels

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/09/27/tsql-lab-14-performing-a-recursive-update-for-more-than-32-levels.aspx

TSQL Labs 13 - Matching a delimited string against another delimited string

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/09/25/tsql-labs-13-matching-a-delimited-string-against-another-delimited-string.aspx

TSQL Lab 12 - Writing a recursive procedure to handle more than 32 levels

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/09/25/tsql-lab-12-writing-a-recursive-procedure-to-handle-more-than-32-levels.aspx

TSQL Lab 11 - Writing a recursive procedure to update the count of child items under each parent category

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/09/23/tsql-lab-11-writing-a-recursive-procedure-to-update-the-count-of-child-items-under-each-parent-category.aspx

TSQL Lab 10 - Performing recursive updates in SQL Server

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/09/23/tsql-lab-10-performing-recursive-updates-in-sql-server.aspx

TSQL Lab 9 - How to find the dependency chain of a database object?

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/09/18/tsql-lab-9-how-to-find-the-dependency-chain-of-a-database-object.aspx

Understanding TSQL Functions - 2: DATALENGTH()

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/09/11/understanding-tsql-functions-2-datalength.aspx

Understanding TSQL Functions - 1: LEN()

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/09/10/understanding-tsql-functions-1-len.aspx

TSQL Lab 8 - GROUPING SETS() - New Grouping function introduced in SQL Server 2008

Moved to http://beyondrelational.com/blogs/jacob/archive/2008/09/06/tsql-lab-8-grouping-sets-new-grouping-function-introduced-in-sql-server-2008.aspx