Can you recode the stored proc in pseudo-code like :

declare var.

open cur

delete from

while not

do 1....

I'm just not sure enough of what you're trying to do in this proc.

It's the alias name for the derived table.

(

select * from zzA

union

select * from zzB

)

becomes a virtual table in the select that can be used like any real table.

DERIVEDTBL just happens...

What you're saying makes sens. But as I said before there's no point in running a command like "Delete from a where col = @col" more than once if @col...

This would seem like a safe way to use dynamic sql.... but I would still use it to call a stored proc in the database... that way you get the...

Maybe I gon't have the right idea of what's happening.

Do you have multiple blocks of codes like the one you sent me?

If this is the case I would suggest that...

I see what's hapenning now.. but if the @mid variable is set only once, then the delete from the table will delete data only once. This is because it...

yes it does... but it's very easy to miss.

But as you pointed out this is something to avoid if at all possible :

Get data from another database. If you...

Might sound simplistic... but is it possible that you don't set @mid in the else part of the proc?

Here's the "one step better" I was missing

thanx aj

Check this out for a better way out :

Dynamic database

I've learned to read between the lines over the years .

I'm glad to help on this forum since I consider than over 75% of...

Now why would you think that I may try to bullshit people just to post messages???

If you want to delete all the records from the table you can do something like this :

Delete from rt_edt

if you don't want the delete to be fully logged...

Don't need a stats course to understand this >>

as of last Friday :

Select 5222.0 / datediff(d, '12/5/2002', getdate()) as FRANK, 138 as POSTS_MAY_FRANK, 1369.0 / datediff(d, '5/10/2004', getdate()) as...

What are you doing actually? Dropping and recreating the triggers to change their fonctionnality or change their code while in production?