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.
seems like it is not working as it is expecting columns as int whereas in above stated example it is varchar...