Thought as much

Thanks for confirming!

Perfect

Added a clustered index

Rebuilt stats for that table

Looked at space used and it's what I would expect

Will look at other tables

Thanks

Damian.

Thanks for the advice Gail. I'll take a look at the indexes

In this instance, there are no indexes on the table

Thanks for the response

It's not healthcare but the scenario described fits what I am facing i.e. in certain circumstances, data is inconsistently stored in the ERP

Agree with the principles of...

Thanks for the suggestions

Will take a look over the next day or so

I've also found this article which looks quite useful:

http://www.sqlservercentral.com/articles/Development/datadrivensubscriptions/2432/

I don't think I have data driven subscriptions as I am using the Standard edition

Is there a work around?

Thanks

Thanks, that seemed to work

Damian.

ok, so it looks like I was inconsistent with my variable names

You have to use the exact same names as used in the SP

e.g. if called @year in the SP,...

Am I going about this the wrong way?

I really want to create a csv file

Give the file a unique dynamic name based upon the date and time (I haven't got...

Thanks

When you say saved credentials, do you mean SQL authentication?

Looks like the restore part does not work after all

I have absolutely no idea why??

For the restore part, I am now getting "Login failed for user '...$'

I have no idea...

Ah, ok I'll go the CTE route

Did consider that but thought I'd try partition and over

Thanks

It's a development server and I'm the only person using it at the moment

I don't think (?) there's anything else going on

Hi

My final code is:

-- Delete #Temp if it exists

if object_id('tempdb..#TempB', 'U') is not null

drop table #TempB

create table #TempB (ID int IDENTITY(1,1), [POLICY_DETAIL_SKEY] int)

-- Create a clustered index for efficiency

CREATE UNIQUE...