Pivot Table

• psconsulting

  SSC Eights!

  Points: 944

  More actions

  February 12, 2003 at 1:26 pm

  #106139

  I need to run a count of record that will determine the length of time since receive date. I was told to use the CASE construct to group by category:

  0-15 days

  16-30

  31-60

  61-180

  181-270

  271-360

  361+

  Then format using a pivot table in Excel to display so that you have on the y-axis the Pend reason and the x-axis the age category.

  I am a novice to TSQL and don't know where to start.

  For example:

  Code Date Received

  HRE 02/10/03

  HRE 02/10/03

  HTR 01/24/03

  Query Results

  0-15 days count 16-30 days count

  HRE 2 0

  HTR 0 1

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  February 12, 2003 at 1:31 pm

  #448785

  Here are some example of pivot table queries:

  http://www.geocities.com/sqlserverexamples/#pivot1

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP