I actually simplified my problem a little.

Each of the tables in the report looks at different periods of sales and a few of them look at all sales for...

So in other words within the select statement of the t-SQL? But the statement brings back 10 years of data how do I create a new column In the code...

Anthony

No real reason why I can't do it as you say. To be honest I had assumed that custom code was the only way forward with this.

I'll give your...

Yes, I can see what it's doing.

I just needed a starting point which is often my problem...

Thanks for all your help Sean - really appreciated....

BO

Sean

I realised this morning that the data I provided wasn't much use on account of it not containing the the actual problem so I've added a few more lines.

Ok, the...

Clearly this is only a small sample of the data but at present I create a report in SSRS that references this table via a stored procedure. The report shows...

Hi Sean

Thanks for getting back to me and I hope you'll be able to help.

Ok, here is the DDL you were looking for:

IF OBJECT_ID('TempDB..#MyTable') IS NOT NULL ...

You guys are ALL awesome!

I owe you all a beer!

MJ

Yes the files are identical in format and it's very likely that the process will be needed going forward. I'd like to go down the SSIS route but I don't...

Cheers Jeff

That's really useful to know and makes my life a little easier!

Cheers Derek

I'll have a play!

Derek

Thanks for your quick response.

That would be great if you could post the syntax, really appreciated.

BO

Daniel - you're amazing!!

Now works perfectly....

Cheers

BO

Thanks everyone.

I'm still having problems but I'm wondering whether I've not been clear in my original query.

I'm trying to RAG in the following way:

Variance greater than 5% negative = RED

Variance...