Posted by parth on 01/08/07 01:43

Hi

I want to achieve the following transformation of data using a stored
procedure.


Source

col1 col2(varchar)
-------------------------
1 1.1
1 1.2
2 2.1
2 2.2
2 2.3
=================

Desired Result

col1 col2(varchar)
--------------------------
1 1.1 | 1.2
2 2.1 | 2.2 | 2.3
=====================


Thanks in advance. :)

- Parth

[Back to original message]