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...
Posted by Jacob Sebastian | with no comments
Filed under:
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...
Posted by Jacob Sebastian | with no comments
Filed under:
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...
Posted by Jacob Sebastian | with no comments
Filed under: