I have a table called Projects and for every row in Projects, there are one or more rows (Called Site) in a related table. In my stored procedure I would like to return the Project and all the sites in a comma diliminated column
So the returned row would look like this:
(Site1,Site2,Site2) as Sites
Thanks for any help.