Pivot sql query

Question

I've SQL Server 2005 table COMPETITOR (Id, Title, cDate, Price) I want to format the query so that its view in Gridview will be like this:

Please help me writing the sql query.

You have to specify what RDBMS you are in since OLAP queries are very DB dependent these days... — Pablo Santa Cruz
– Pablo Santa Cruz, Commented Jan 13, 2010 at 11:59

Doogie · Accepted Answer · 2010-01-13 13:06:18Z

2

SQL 2005 supports PIVOT - the Books Online doc is http://msdn.microsoft.com/en-us/library/ms177410(SQL.90).aspx

The main shortcoming I've found with the PIVOT stuff is that you must specify the column names, although you can use a query beforehand and inject the values into a varchar variable and then execute that.

answered Jan 13, 2010 at 13:06

Doogie

8156 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pivot sql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related