Search 
Sunday, February 05, 2012 ..:: Examples » Pivot Table Queries ::.. Register  Login
 Pivot Table Queries
Sting Columns Together Using FOR XML PATH - Saturday, April 19, 2008
This example takes columns that are on separate records and stings them together using FOR XML PATH. When stinging the columns together it places commas between.
 read more ...

Pivot Table With All Column Values Strung Together - Wednesday, December 19, 2007
Builds a report where each line contains all the values stung together from table rows for a given key.
 read more ...

Pivot Table Without Case Statement - Wednesday, December 19, 2007
Dynamically create a pivot table report without the use of a case statement.
 read more ...

Pivot Table Summorized By Year With Case Statement - Saturday, December 15, 2007
This example creates a pivot report showing summarized column data based on a year using case statement.
 read more ...


  
SQL Tools Heaven
SQLMonitor_160x600_BackToTheFuture_M2
SQL Backup
Copyright 2007, 2008 by SQLServerExamples.com   Terms Of Use  Privacy Statement