Best way to query data....

• ikorenbl

  SSCommitted

  Points: 1750

  More actions

  January 25, 2005 at 12:09 pm

  #60387

  I have a table with the date and data elements in it.

  I need to produce a resultset in the following manner:

  On columns: Yesterday, WeekToDate, MonthToDate, Last Month, YearToDate

  On rows: data element 1, data element 2, data element 3, ....

  What's the best way to query this table? It has to be fast for the front end.

  Thank you

   

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  January 25, 2005 at 1:12 pm

  #539032

  1.  Build a cube

  2.  Build a summary table that gets updated nightly.

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net