edited to remove too much distractions from the thread.

I get the trepidation of cloud computing but thats looking pretty inevitable with today's tech momentum. It would make for...

Where I work the final responsibility on stored procedures is mine. But I am okay with developers writing a first version and then handing it to me for review....

We really don't know why they are removing stored procedures tho. I'm guessing that the project(s) could be becoming a burden on the programmers and they could be reaching...

Give this version a shot, I edited Steve's a bit, needed quotes around the "print" arguments.

edit: fixed schema section, restored Steve's original tests for the conditionals.

could you tell me the definition of "purge"? I've been working at my current job for a bit and I might have been neglecting this duty! It sounds important!

You could also just use your original query inside a cursor / dynamic sql pairing, actually executing the sql is left as an exercise for the reader

declare dbfetcher...

unique identifier is not a numeric that can be fit into an int. even a bigint is probably not a large enough integer type to contain the unique identifier type...