Concatenate child data values without functions/procedures
Posted on 2006-04-17
I have a table:
RefCaseId (PK) Data1 Data2, etc (various columns)
1 AAA AAA
2 BBB BBB
3 CCC CCC
RefCaseId (FK) Comment (varchar)
I need to select and get results like this:
RefCaseId Data1 Data2 Comment(s)
1 AAA AAA Comment1. Comment2.
2 BBB BBB Comment3.
3 CCC CCC Comment4. Comment5. Comment6.
I've seen all the posts that suggest using UDFs, etc. The problem is I can't use functions or SPs because I only have read access to the db/server. So - is there a way to do this in a query only?