Thanks very much for the quick response I will look at both replication and the staging table.

Right Click on the Column header and select sub-total, there is no option for avg at this time according to Microsoft Reporting Services in Action.  (Book has been a real help) ...

Thanks for the help, I used what you told me to try and it returned the first month on the date table, not the month = the week of date. ...

No, when I use DTS to make the table they keep the same format as the table of origin, Varchar  I convert them to 2005-05-05 date when I call them in...

Good Morning again,

I have to many tables to post them here so I will try and explain this a lot clearer this time.  I have a table 'Date' that has...

The tables are actually dropped and re-created on an hourly basis during normal operation hours because of the information being pulled across being so time sensitive.  We do this on...

Follow-up:  I recently moved the DTS package from the development server to the LIVE server.  Now that the package is moved it only failed the first time and had run...

Thanks again this will be very useful in the future!

Fantastic!!  I am still not sure how it works (this is still all very new to me) but it works and gave exactly what I am looking for.  Thanks for...

Good Morning,

I have tried a few different things this morning and the error does not occur at the same time everytime.  Sometimes when I execute the package it dies right...

I already have that at the front of the Stored procedure and it hasn't made a difference.  Thanks for the suggestion!

After looking through some of the other forums and saw a couple of things that made a question or two pop up.  Could this be caused by using temp tables,...

Thanks for all of yur suggestions I wil keep plugging away and post what ever I find does the trick.

I looked at the StoredProcedure and there are not cast in side it... but I do have a CASE

case strTimeBasisCode

       when '1' then 0.1

       when '2' then 0.01

       when '3' then 0.001

       when '4'...

I deleted all of the parameters on the Parameter tab.  Then went to the 'QUERY' or main tab and all that appears is the NAME, DATA SOURCE, STORED PROCEDURE and...