Converting Multiple rows of data into one row...

Database
Enthusiast

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...

1 REPLY
Teradata Employee

Re: Converting Multiple rows of data into one row...

Hi,

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

Regards, Adeel