What about setting up a trigger to perform the delete on a one by one basis?  It would be transparent and would perform well...

Also...I know that most people avoid using...

Farrell... there is a 2 steps solution... i think this will work fine... at least it worked with my configuration...

But I suggest that...

If # of items would vary in time, you'd never get it running with a single select statement.

I think concatenation would be the rigth approach. Even if you need...

Another adition...

You can use SELECT statement in place of a PRINT statement to get some readable output OR in place of a SET statement to set variable values...

The diferences are...

Thanks you both...

Creation in order, is not impossible, but almost is... i'm not migrating a couple of stored procs... there are several hundreds stored and functions... not all of them...

Hi

Would you post the error message??

In advance, it's not a recommended idea to use cascaded deletes... it's better if you implement something like this using triggers...

And... supose the next case:

t01              ...

Paula

I think you can re arrange your SP to produce a temp table with records marked to delete, instead of deleting them directly (changinf DELETE... for a INSERT INTO #TempTable...

Bryan

If you read the precedent comments and besides them you still insist on hardcoding our list, since it is length variable you can use a temp. table to store its...

Hi

In your example, you are forcing srt1 and srt1nm to be NULL

SELECT 12345 AS award_id, 0.95 AS sumpro, NULL AS srt1, NULL AS srt1nm, NULL AS srt2, NULL AS...

This is very obvious I think, but you'll need to maintain an historic for each result set retrieved...

Hi again...

As i can see you recover just a few fields from each table in your stored proc... so... where are this values going?? I mean, what are you doing...

I think the fields CreateDT and UpdateDt you've created are datetime, no?

Why are them not reliable? Where do you update those fields?

You will need just a bit field...

Thanks.

Changing option in EM/Mgmnt/server Agent/JobSystem worked ok!

Just for tracing purposes...

!!!

Hi! Helen, Jim...

Jim's solution will work (once rewrited in a correct way) but if you have more tha a few applicants, would be very expensive...(see below)

try this... it would work...