CONCATINATE

Question

Post reply

CONCATINATE

mikejohn-460140

Grasshopper

Points: 21
More actions
July 5, 2007 at 10:06 am

#174303

Hi,
i have many rows like
example
row1: 123   abcd   xxxx   yyyy  7645
row2: 123   abcd   xxxx   yyyy  4567
i want to get these values in a one row and last column with comma like :
row1: 123 abcd xxxx   yyyy 7645,4567
how can i do it
plz help

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

bledu SSChampion Points: 12335 More actions · Answer 1

please stop double posting, you have another post with the same problem.

as for your solution you can have a look at these posts

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=376899

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=379131

Everything you can imagine is real.

mikejohn-460140 Grasshopper Points: 21 More actions · Answer 2

Hi bledu,

Iam sorry, i didnt see

i joined recently.

Thanks

bledu SSChampion Points: 12335 More actions · Answer 3

Mike,

i didn't mean to be rude or anything its just that if you post something once, you are almost guaranteed that people will have a look at it. if you don't get a response you can plead for more help on the same post.

Everything you can imagine is real.