Monthly Yearly quarterly report

• vblllove

  Ten Centuries

  Points: 1273

  More actions

  June 5, 2008 at 4:56 am

  #208015

  Im having a problem on displaying the Monthly report (12 month) using sql server 2000. On the sql server 2005 I can user the CTE with pivot table and is easy but in tsql I dont have that Option.

  I want to display Total monthly sales by clients + on column Average , Yearly total and the last three month average.

  best regards

• raja_saminathan

  SSCommitted

  Points: 1607

  More actions

  June 5, 2008 at 11:33 pm

  #825275

  Could you post the sample Datas along with the Expected Results

  Rajesh

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  June 6, 2008 at 12:31 am

  #825287

  Read topic "Cross-Tab Reports" in Books Online.

  Tell us if it helped.

  _____________
  Code for TallyGenerator