A simple T-SQL statement to create a list of lookup values

Posted on SQL Server Central See other posts from SQL Server Central
Published on Fri, 28 Sep 2012 06:00:00 UT Indexed on 2012/09/30 9:44 UTC
Read the original article Hit count: 195

Filed under:

In this article, we provide a simple way to get a comma delimited list from a table of entries without having to use a CURSOR or a WHILE loop to read through the table.

SQL Backup Pro Are you sure you can restore your backups?
Run full restore + DBCC CHECKDB quickly and easily with SQL Backup Pro's new automated verification. Check for corruption and prepare for when disaster strikes. Try it now.

© SQL Server Central or respective owner