Sean Lange (4/18/2014)
J Livingston SQL (4/18/2014)
quick Google....heres an article that may helphttp://davidduffett.net/post/5334646215/get-a-comma-separated-list-of-values-in-sql-with-for
JLS, I can't get that link to load. It just spins and spins. From the url is it using FOR XML like the example already posted here or is there another approach being used. I am curious because using FOR XML to generate a comma separated list is the easiest and fastest way I know of.
odd...worked earlier...all I get now is spins as well ???...all it was an explanation of how XML path works in easy steps.....which the OP could find via googlefoo 😀
It wasn't a better method.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day