Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: Create a comma-delimited list from several rows of data (SQL)
Title: Create a comma-delimited list from several rows of data Language: SQL
Description: Uses COALESCE to transform rows of data into a comma-delimited string of values Views: 449
Author: Raj Ramteerath Date Added: 9/14/2007
Copy Code   
DECLARE @List varchar(1000)
SELECT @List = COALESCE(@List + ', ', '') + ColumnName
FROM TableName
SELECT @List