Hi all,
I 've a following table with two columns id & name.
Table : A
id name
1 A
1 B
1 C
2 D
2 E
3 F
and I need the output like this with four columns id,name1,name2 &name3.
Table: #B
id name1 name2 name3
1 A B C
2 D E NULL
3 F NULL NULL
I dont know how to implement. Sorry for the bad alignment.Pivot table will not work for this. I am still trying. Any help is greatly thankful. plz help.....
I 've a following table with two columns id & name.
Table : A
id name
1 A
1 B
1 C
2 D
2 E
3 F
and I need the output like this with four columns id,name1,name2 &name3.
Table: #B
id name1 name2 name3
1 A B C
2 D E NULL
3 F NULL NULL
I dont know how to implement. Sorry for the bad alignment.Pivot table will not work for this. I am still trying. Any help is greatly thankful. plz help.....