This article has been rewritten to correct an error and to incorporate some lessons learned including a fix for parallelism, a work around for paritioned tables/views, and to demonstrate additional proofs. That article is located at:
http://www.sqlservercentral.com/articles/T-SQL/68467/
The discussions for the old article are still available at the following URL
http://www.sqlservercentral.com/Forums/Topic449802-203-1.aspx
Thank you for your patience during the rewrite.
Sincerely,
--Jeff Moden
In this article by Steve Jones, he shows you how to manipulate strings.
2004-04-05
17,655 reads
The second part of Steve Jones's series on programming and manipulating strings in T-SQL.
2002-05-31
15,613 reads
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
2001-06-21
10,868 reads
Sp_MSforeachdb gives a DBA the ability to cycle through every database in your catalog. Find out how to use it.
2001-05-31
13,709 reads
Is there such a thing as a task where you would not need a cursor? Hidden in the depths of the master database are a series of stored procedures that can replace some cursors with these one-liners.
2001-05-22
14,209 reads
