Transposing Data of Table as Columns in SQL

TimHop12

Lets consider the following query:

Expand|Select|Wrap|Line Numbers

Select Col1, Col2 from Table1 where Colx = 'A5100650867'

This gives result as:

Expand|Select|Wrap|Line Numbers

 Col1                         Col2

E-mail Address                xyz@GMAIL.com

Web Site                      www.GOOGLE.com

I want the outcome as:

Expand|Select|Wrap|Line Numbers

 E-mail Address         Web Site

xyz@GMAIL.com           www.GOOGLE.com

So the new columns inthe resultset are 'E-mail Address' and 'Web Site'.

[HTML]Note: This is just a simple example I have considered. Potentially there can be multiple things like that e.g. E-Mail, E-Mail2, Pager, Mobile etc etc...[/HTML]

Please advice on this. Thank you.

dusana

Quote:

Originally Posted by TimHop12

Lets consider the following query:

Expand|Select|Wrap|Line Numbers

Select Col1, Col2 from Table1 where Colx = 'A5100650867'

This gives result as:

Expand|Select|Wrap|Line Numbers

 Col1                         Col2

E-mail Address                xyz@GMAIL.com

Web Site                      www.GOOGLE.com

I want the outcome as:

Expand|Select|Wrap|Line Numbers

 E-mail Address         Web Site

xyz@GMAIL.com           www.GOOGLE.com

So the new columns inthe resultset are 'E-mail Address' and 'Web Site'.

[HTML]Note: This is just a simple example I have considered. Potentially there can be multiple things like that e.g. E-Mail, E-Mail2, Pager, Mobile etc etc...[/HTML]

Please advice on this. Thank you.

try this

Select ltrim(rtrim(Col1)) as Col1, ltrim(rtrim(Col2)) as Col2 from Table1 where Colx = 'A5100650867'

Transposing Data of Table as Columns in SQL

re: Transposing Data of Table as Columns in SQL

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about