Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Monthly Yearly quarterly report Expand / Collapse
Author
Message
Posted Thursday, June 05, 2008 4:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 9:58 AM
Points: 231, Visits: 197
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
Post #512004
Posted Thursday, June 05, 2008 11:33 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 25, 2010 10:52 PM
Points: 89, Visits: 273
Could you post the sample Datas along with the Expected Results


Rajesh
Post #512688
Posted Friday, June 06, 2008 12:31 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, April 21, 2014 10:48 PM
Points: 4,570, Visits: 8,317
Read topic "Cross-Tab Reports" in Books Online.

Tell us if it helped.
Post #512704
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse