Browse by Tags
All Tags »
PIVOT (
RSS)
Sorry, but there are no more tags available to filter with.
In the previous post we saw an example of the PIVOT operator introduced in SQL Server 2005. We saw a simple example that transformed rows to columns using the PIVOT operator. In this post, we will examine how to achieve this SQL Server 2000. Here is the...
Generating PIVOT/CROSS-TAB queries is one of the common requirements that we find in our day-to-day programming life. SQL Server 2005 introduced a new operator: PIVOT, which made generating pivot/cross-tab results much easier. Though the PIVOT operator...
I suppose most of us might have come across the following situation several times in the past. Let us say for example we need a result set as following from a table which has data as follows. This essentially means the task is to...