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?

Sounds like dynamic sql task here... What problem are you trying to solve?

I've been told to stay away from that include file so I'll forward that to you.

here's the bit that's missing :

response.write "No Of Records = " & rs1.fields("Fieldname").value...

Sorry didn't see this last question untill now...

just add

CASE WHEN datepart(m, tblInvoiceMaster.invoice_date) = 5 AND year_col = 2004 THEN...