Merge Rows in Sql Server

Hi Expert,

I have provided sample table in sql server :

ID      Name      Dep                Add
1      A               N                A-1
1      B               K                A-1
1      C               M                A-1
2      D               Z                A-2
2      E               O                A-2

Note: Above rows can be dynamic, it is not static like ID = 1 can have 3 rows as stated above or it could have more  or less than 3 as well.

Expected output is:
ID      Name1      Name2      Name3      Dep1      Dep2      Dep3      Add
1      A                  B                 C                N                K                M              A-1
2      D                  E               NULL        Z                O              NULL        A-2


Hopefully looking forward to hearing from you.
satmishaAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
so, you need a "dynamic crosstab" function:
http://weblogs.sqlteam.com/jeffs/archive/2005/05/02/4842.aspx
0
 
satmishaAuthor Commented:
Thanks for your reply..
seems like it is not working as it is expecting columns as int whereas in above stated example it is varchar...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I did not test the function, the key for you is to use "othercolumns" (@OtherCols) argument ...
0
 
satmishaAuthor Commented:
Thanks angelIII,

Apologies for late reply

Above stated didn't work.

But I got the solution by making sql function with special character saparated column.
0
 
satmishaAuthor Commented:
request to pls close this question as provided answer was not appropiate.. n I am unable to see any option to close by my own...

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.