SQL Server Performance Forum – Threads Archive

select qry

I have table like this sno name
————
1 A
1 B
1 C
2 D
2 E
2 F badly I want to show output like this with out using cursors sno name
————
1 A B C
2 D E F
advance thanks SURYA

---

see herehttp://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx ——
> KH <

---

Read that article fully. The suggested method is more effecient Madhivanan Failing to plan is Planning to fail

---

thanks guys SURYA

---

]]>