Yeah it needs to be a daily aggregate to appear in the attached excel spread sheet format

Hi DVA2007

Will the aggregate results be grouped by date in the new table, thats where my main problem is coming from, the need for the aggregated results to be group...

Thanks all

I used the foloowing which worked for me:

SELECT SUBSTRING(CAST(OrderDate AS VARCHAR),1,11) AS OrderDate, .......

This part of the query returned o as dates, or maybe there is something I...

will the results appear as a pivot table with 02/09/2008, 03/09/2008 as rows?

What do you mean by CTE?

because I used:

USE db

declare @Threemore int;

declare @all int;

set @Threemore = (SELECT...

Thanks you guys have helped me alot, I ran the query with you guidnace and it worked fine, but i was wandering if there is a way I can aggregate...

Hello Gary

You may need to expantiate on what you mean, the method you stated earlier, but I was able to get the desired output with the UNION and not the...

I used a query to generate the result set which is:

Select Col1,Col2,Col3,Col4,Col5,Col6,

FROM Table A

Where Date BETWEEN GETDATE() AND GETDATE()-1

Its a simple query and not a stored procedure.

I tried the union all but it gave me duplicate records

Yeah, my mind went to SSIS, will have a go at it and post my findings here.

Yeah, thanks later realised that I had to either upgrade the reporting service and server to 2008 from 2005, or install a whole new 2008 enviroment, how funny for a...

Check the Database Service Credential in the Reporting Service Configuration Manager, and change it your domain\user account, that may do the trick, as it did for me with SSRS 2005...

Checked could only find bulk export and import to and from XML files

Using the cross join gives me a cartisian product which is not what i want