Monthly Archives: February 2009

T-SQL Hack to Turn a Set of Row Values into a Delimited String

Ever want to turn multiple rows into a comma separated list when you are querying your database? Here’s a quick way to get it done using “FOR XML PATH(”)”:   DECLARE @comma_delimited_list VARCHAR(6000) SELECT @comma_delimited_list = ( SELECT productName + … Continue reading

Posted in MS SQL Server | Leave a comment

TechNet Magazine IT Toolbox: March 2009 Issue

The March 2009 issue of TechNet Magazine is out on the website.  Check out my IT Toolbox column here: http://technet.microsoft.com/en-us/magazine/dd440965.aspx In this issue I covered: TuneUp Utilities 2009: Tweak your system Book: Configuration Manager 2007 Administrator’s Companion HijackThis: Find problems … Continue reading

Posted in Microsoft TechNet | Leave a comment