All Forums Analytics
pmhere 1 post Joined 03/07
21 Mar 2007
Concatenate Rows In A Table

Hi,I am looking for a query that can do the following.Input Column1 Column21 A1 B1 C2 D2 E2 F3 G4 H4 IOutputColumn 1 Column21 A,B,C2 D,E,F3 G4 H,IPlease suggest.Thanks Prashant

sachinp17 53 posts Joined 11/06
23 Mar 2007

Hi, In a single query i don't think it is possible. Try through stored procedure.Regds,sachin

dnoeth 4628 posts Joined 11/04
23 Mar 2007

Hi Prashanthttp://www.teradata.com/teradataForum/shwmessage.aspx?ForumID=1&MessageID=6938Dieter

Dieter

jdarton 4 posts Joined 10/05
05 Mar 2012

Dieter, the link you provided is dead.  Can you supply the solution?

You must sign in to leave a comment.