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

• Next in forum: Re: stored procedure to concatenate column value sin a single cell?
• Prev in forum: Re: How to stop query in QA from continuing
• Thread view: stored procedure to concatenate column value sin a single cell?

[Reply to this message]