December 4, 2008 at 8:42 am
Hi All,
I have a table that looks like the example below,
subject time1 time2 result
1069732713734793:TS15
1069732713734798:TS20
1069732713734787:TS9
106973271373411358:TS35
how can I write a query that will concantanate
the results to give me the following result
subject time1 time2 result
1069732713734 793:TS15,798:TS20,787:TS9,11358:TS35
In other words, I need to join all the results into one field
Any help will be highly appreciated
Nneka
December 5, 2008 at 4:47 pm
Create a concatenation user function and use it in a summary query.
Here's a great write up by Jeff Moden. Let me know if you have any questions after.
http://www.sqlservercentral.com/articles/Test+Data/61572/
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply