----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: jacobseb Message 1 in Discussion Transforming rows to columns (PIVOT/CROSS TAB) and columns to rows (UNPIVOT) may be one of the common requirements that all of us must have seen several times in our programming life. SQL Server 2005 introduced two new operators: PIVOT and UNPIVOT that made writing cross-tab queries easier. I have posted an example that transforms rows to columns using the PIVOT operator here: http://www.sqlserverandxml.com/2008/09/pivot-cross-tab-sql-server-2005.html PIVOT operator is available only in SQL Server 2005/2008. It does not exists in SQL Server 2000. I have posted another version of the above sample code that works in SQL Server 2000. You can find the post here: http://www.sqlserverandxml.com/2008/09/pivot-cross-tab-sql-server-2000.html I have posted one more example, that performs the reverse operation (columns to rows) using UNPIVOT. You can find it here: http://www.sqlserverandxml.com/2008/09/unpivot-sql-server-2005.html Regards Jacob Sebastian, SQL Server MVP ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
