• shashi kant (10/13/2009)


    Supurb Article, I was looking for such article.

    Do you have SQL Server 2000 scripts for the same

    Regards

    Shashi Kant Chauhan

    The code works and has been tested against 2000, 2005 and 2008 servers. The backend repository must be 2005 or 2008. If you don't have a 2005 or 2008 SQL Server, SQL Express will work. Additionally the only pieces that are 2005/2008 specific are the CTEs used in the forecasting procedures. If you really want to use a 2000 repository you could rewrite these queries to uses subqueries instead of CTEs. The other piece that is 2008 specific are the SSRS reports. The reports are very basic and could be re-created using the SSRS wizard for 2000 or 2005 SSRS. Here again a SQL 2008 Express with Advanced Services (includes SSRS) would suffice.