Archives of the TeradataForum

Message Posted: Tue, 09 Oct 2012 @ 20:30:48 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Experts,

Is there any simple way to transpose a column to a row in Teradata? If my data is as shown in case A, I would like to have my result as shown in case B. Any lead would be helpful.

Case A

     Username    Database   Table   Access Right
     Ray         AAA        ABC?    R
     Ray         AAA        ABC     I
     Ray         AAA        ABC     D
     Ray         AAA        ABC     U

Case B - This is how I would need my result

     Username   Database   Table   Accessright
     Ray        AAA        ABC     R , I , D , U

Thanks

Roopalini

	<Prev	Next>		<<First	<Prev	Next>	Last>>