Monthly Yearly quarterly report

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 7,2000 » T-SQL » Monthly Yearly quarterly report

Add to briefcase

Monthly Yearly quarterly report

Expand / Collapse

Author

Message

Posted Thursday, June 05, 2008 4:56 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, August 04, 2011 3:46 PM
Points: 230, Visits: 196

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

raja_saminathan

Posted Thursday, June 05, 2008 11:33 PM

SSC 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

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:01 PM
Points: 4,540, Visits: 8,184

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