Search results for: Cross Tab Query
12-Dec-2012
SQL SERVER Cross tab Query with Pivot (Dynamic Pivot)
As I mentioned earlier, PIVOT, in my earlier post, where we have reviewed the PIVOT with static columns. In practical world, we may need to have dynamic columns that needs to be displayed as below:
07-Nov-2012
SQL SERVER: Cross tab query with PIVOT
We had a User group meeting for "Cross Tab Queries", where I have explained how to write PIVOT queries. Many times developer has an issue while writing query with PIVOT. Let me have a sample code for query with PIVOT keyword.
