Weekly Report Query

• shatrughna

  Ten Centuries

  Points: 1037

  More actions

  September 1, 2009 at 3:10 am

  #385291

  Hi All,

  I want to create a weekly report by specifying a query between two dates.

  Date Range is not fixed.

  Result should come as below

  Week1 Week2 Week3 Total

  100 200 300 600

  Shatrughna

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  September 1, 2009 at 3:41 am

  #1047376

  Hi

  SQL is not good at pivoting data , even with the PIVOT operator you have to know your finite list of columns.

  Take a look at BOL (Books online) for more details

  ---

  
  Clear Sky SQL
  My Blog[/url]

• kupy

  SSCommitted

  Points: 1652

  More actions

  September 1, 2009 at 9:38 am

  #1047621

  Hi,

  You can also use the cross tabs as in jefff grate articlae

  http://www.sqlservercentral.com/articles/T-SQL/63681/

  see also part 2

  http://www.sqlservercentral.com/articles/Crosstab/65048/

• shatrughna

  Ten Centuries

  Points: 1037

  More actions

  September 2, 2009 at 2:50 am

  #1047983

  Thanks everyone.

  Shatrughna