SiSense BI Evolved
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Another UNPIVOT Example

We saw an example of UNPIVOT in the previous post . Let us see one more UNPIVOT example in this post.  I wrote this query to help some one in one of the SQL Server forums. Here is the source data: /* SquadID Date Area01 Area02 Area03 Area04 Area05...
Posted: 10-11-2008 7:53 PM by Jacob Sebastian | with no comments
Filed under:

An example using UNPIVOT (Transforming Columns to Rows)

In the previous post we discussed the PIVOT operator introduced by SQL Server 2005. We saw how to transform ROWS to COLUMNS using the PIVOT operator. This is the source data that we examined in the previous post. /* id --------- -- 1 2 3 4 5 6 7 8 9 10...
Posted: 09-29-2008 7:40 PM by Jacob Sebastian | with no comments
Filed under:

Copyright © Beyondrelational.com