tsql to get the columns in to rows

Question

question

sand143eep asked Jun 21, '13

tsql to get the columns in to rows

Hello i have the table as shown below: id product version 23 telenor v1 23 uninor v2 now i need the output format as: id product1 product2 version1 version2 23 telenor uninor v1 v2 can any one help with the tsql statement.

sql-server-2008 sql-server-2005

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton ♦♦ commented · Jun 22, 2013 at 07:05 PM

something like a multi-pivot, as per this blog post? http://blogs.msdn.com/b/kenobonn/archive/2009/03/22/pivot-on-two-or-more-fields-in-sql-server.aspx

0 ·

Answer 1 · 2013-06-28T21:19:39Z

sunil2711 answered Jun 28, '13

http://www.mssqltips.com/sqlservertip/2783/script-to-create-dynamic-pivot-queries-in-sql-server/

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2013-06-24T09:41:11Z

teddy answered Jun 24, '13

You can reference above opinion. If your output is fixed,then you can use cursor to solve.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jeff Moden commented · Jul 19, 2013 at 11:09 PM

You just don't need a cursor to do this.

0 ·

question