Today’s Link: Common Solutions for T-SQL Problems
How to PIVOT data using TSQL? How to increment an Alpha-Numeric Value? How to create a comma-delimited list from a column? How to automate DBA tasks?
Ok, you don’t want explanation, right? You only want to go get a sample and tailor your own solution from that.
Here’s the link: http://code.msdn.microsoft.com/SQLExamples