SQL Server Performance Forum – Threads Archive

How to build this query

Hi Guys,
I’m really confused to build this query.
consider this sample data
columns —-
ids iddesc
1one
10NE
2TWO
2tw0
req o/p
1 one,0NE
2 TWO,tw0
Thanks

---

Refer this
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true Madhivanan Failing to plan is Planning to fail

---

Thanks alot Madhi,
Great article.
Even i was thinking of UDF but then i thought of giving it to you gurus a try.

---

]]>