Alternative for PIVOT - 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 2005 Forums

Transact-SQL (2005)

Alternative for PIVOT

Author

Topic

goodsolution
Starting Member

38 Posts

Posted - 2009-11-12 : 12:43:22

Hey all,
Can any one let me know the alternative way to write t-sql to get pivot logic done without using PIVOT keywords (or pivot logic)?

Because Netezza dont support PIVOT keyword.

Thanks

-Thanks

ranganath
Posting Yak Master

209 Posts

Posted - 2009-11-12 : 23:12:54

try with this

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=131029

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/dynamic-crosstab-with-multiple-pivot-columns.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources