kapil_kk (6/26/2013)
Hi Sean,I know to print comma seperated values using FOR XML.
But I was trying the same solution using COALESCE like this:
DECLARE @var varchar(max)
SELECT @var = coalesce(@var +',','') + term from Something where TYPE = 'subject'
select @var, ID from something
group by ID
its printing all term values in a single line... Can you please tell me what to modify in my script to get the same output as using FOR XML as you did
No clue how you could do that Kapil. I think you would have to use a subquery to keep the ID in synch but then I don't have any idea how you would do it.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/