TSQL: Concatenate Multiple Rows into String

Posted in Labels: | at 8:35 AM

use Northwind

declare @CategoryList varchar(1000)
select @CategoryList = coalesce(@CategoryList + ‘, ‘, ”) + CategoryName from Categories

select ‘Results = ‘ + @CategoryList

Read Users' Comments (0)

0 Response to "TSQL: Concatenate Multiple Rows into String"

Post a Comment

Subscribe to: Post Comments (Atom)