Posted by dmarkle on 01/08/07 02:39

You pretty much have to use a CURSOR to make this happen. (Though
there are some other tricks you can use, a cursor is your best option
here.) For optimal performance, use a FAST_FORWARD cursor.

-Dave
http://www.markleconsulting.com


parth wrote:
> 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]