Page 1 of 1

column manipulation

Posted: Thu May 18, 2006 12:49 pm
by samba
I have two columns

ParaName ParaOutput
JobName xxxxx
JobStartTime xxxxx

I need to convert columns into rows..

how to convert, which stage i need to use

please help me

Posted: Thu May 18, 2006 2:21 pm
by us1aslam1us
Hi samba

What you are trying to do is known as "Vertical pivot".Search the forum with this as keyword and you will have enough info.

Thanks
Sam

Posted: Thu May 18, 2006 2:29 pm
by ray.wurlod
Is this a parallel job question or a TX question?

Posted: Thu May 18, 2006 2:33 pm
by us1aslam1us
ray.wurlod wrote:Is this a parallel job question or a TX question?
I apologize for not looking at that.But it has been mentioned as a parallel..

Sam