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 5, 2008 4:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, January 9, 2015 12:58 PM
Points: 231, Visits: 199
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 5, 2008 11:33 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, February 6, 2015 4:11 AM
Points: 91, Visits: 280
Could you post the sample Datas along with the Expected Results


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

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:15 PM
Points: 4,593, Visits: 8,435
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