Link to home
Create AccountLog in
Avatar of satmisha
satmishaFlag for India

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of satmisha

ASKER

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...
I did not test the function, the key for you is to use "othercolumns" (@OtherCols) argument ...
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.
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