Thanks for your vote of approval Grant.

The database has been alive for about 7 years now and they would like to keep about 18 months online.

We'll proceed with a few...

No reason specifically. I started with some pseudo code given to me by the client and it just went from there.

It runs in less than 1 second and shouldn't ever...

Many thanks for your reply. I suspected that I wasn't far away but i couldn't see what the issue was. In the meantime i built a cursor to do it...

Thank you for responding so quickly.

I can provide what you asked for however the issue is not the fact that the query doesn't give the desired results.

Its the fact...

Firstly let me apologise for not responding to your response earlier. Life has been quite frenetic around here lately.

Your response was exactly what i needed. It your code that...

Many thanks J Livingston.

Thanks also for introducing me to the WITH statement.

I've utilised your code into my application and it seems to be doing the trick.

I had to do a...

Kevin

Thanks for responding

i take your point about providing some data creation scripts.

Please find my attempt below.

About your other comments. I can understand the hit on storage however I am intrigued...

Looks like i have some home work to do

Thanks

I still have both machines so i will do that over the weekend.

Thanks

I wondered about the power consumption of the keyboard, lots of flashing LEDS.;-)

I took your advice and cranked up the power setting to "Performance" accepting the defaults for that...

Thank you Jeff for responding.

I've run your code and it does do as you say and I guess in a way what I had asked.

The intention of the code that...

Greetings.

I've found the issue.

I did the fetch and the processing in the wrong order. This means that the value of @@FETCH_STATUS does not change to a value != 0 before...