All Forums Database
barani_sachin 141 posts Joined 01/12
02 Apr 2012
Converting Multiple rows of data into one row...

Say i have data like below

TEMP1

TEMP2

TEMP3

TEMP4

It need not be only four, it can be any number.

 

And i want the output in the following format

 

TEMP1TEMP2TEMP3TEMP4

 

 

Thanks in advance...

Adeel Chaudhry 773 posts Joined 04/08
02 Apr 2012

Hi,

 

You can do it either by using recursive view, or by looping in a procedure.

 

Regards, Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.