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 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 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

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