Rows to Column. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Rows to Column.

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-05 : 09:08:30

Kabir Rathi writes "Hi,
I shall be thankful to you, if you please give me solution to my problem.

I'm having data as

Business Measure  Datecode Present

B1       M1        20010101  Yes
B1       M1        20010102  Yes
B1       M1        20010103  No

B2       M1        20010101  Yes


I need a select statement(SQL Server) showing the following format

Business   Measure   20010101    20010102   20010103
B1         M1        Yes         Yes        No
B2         M1        Yes

Thanking you in Advance.

Regards
Kabir"

andre
Constraint Violating Yak Guru

259 Posts

Posted - 2002-02-05 : 10:13:29

Check out this article on creating a pivot table:
[url]http://www.sqlteam.com/item.asp?ItemID=5741[/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources