Hello Everyone,

Please get me the solution for the problem specified below:

Consider a table >

Column Name A B

              23 g
              26 m
              23 h
              55 a
              26 k
              23 s

I have to come up with a SQL query which can provide me with the output >

              23 g, h, s
              26 m, k
              55 a

Regards,
Rahul

select * from test order by no1,no2

Amit

No, that's not what the OP asked for.

Actually, the only way to do this in a supported and well defined way is to use a cursor (ugh). The operation is called "string aggregation" and there are ways to accomplish this, it's just that most of them cannot guarantee that the aggregation will always result in the same output, or rather, the same same order of the output (sub)strings.

Refer to this topic:
http://p2p.wrox.com/topic.asp?TOPIC_ID=6611

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com