Hiya,

You say these are staging tables...

Couple of questions then:

1.) Do these tables get cleared down as part of the staging process?

2.) If the above is true how often does this...

As everyone has said, there are no catch all scripts, but if your company is willing to purchase software, we use Idera's SQL Doctor which I have found very useful,...

No worries C0ldCoffee. 🙂

It's always good to have a second pair of eyes to check things over.

Apostrophe's and variables always seem to give me a headache though. Seems to be...

Hi C0ldCoffee,

Thanks for the reply.....

Why would I need to do this?

I could get away without using that variable at all I suppose, and just put the COUNT statement straight...

Hi Lowell,

the other one we use here is Code 18 .....

The problem is 18inches from the keyboard... lol

Sorry to anyone who read this.

Hope it gave you a laugh, worked out the problem.....

PICNIC (Problem In Chair Not In Computer) on my part forgot the + between the last...