Damn, beaten by 2 minutes, Adam!

Should take a course in fast typing

What about

UPDATE Table

    SET   qty_total =

     case when start_qty - end_qty < 0 then 0 else start_qty - end_qty end

I don't think this is possible using plain T-SQL. However this might be interesting for you:

http://www.microsoft.com/technet/scriptcenter/tools/logparser/default.mspx

Oh, and while we're at it. Shouldn't

Functon

read

Function

Sorry, I meant there are more severe and not so funny errors than this additional E.

Sorry, but I have never seen a Merge Join when you use NOT EXISTS. You should always get Nested Loops.

From my observations I have seen NOT EXISTS performing better...

I might be wrong, but I think the NUMERIC data type is still included in the SQL 2003 Standard. So, I guess it will take some time, before one can...

What is the E-Mail address for it? sqlwish@microsoft.com ?

I wish there were only such mistakes in SQL Server

Dave,

just a note on this

LEFT OUTER JOIN

..

WHERE ... IS NULL

While this solution surely works, you'll find the same rewritten to use (NOT) EXISTS to perform generally better. Try...

See if this will help you:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Yes, after posting my reply I became aware of it. Sorry, no good idea other than the one you already had. Maybe this can be done via SQL-DMO, but I...

Success 

Back to your question:

Probably the easiest solution is to check the appropriate option in EM when you click on "Generate Script"

More than one way to skin that cat

http://www.microsoft.com/sql/techinfo/tips/administration/resultset.asp

http://www.aspfaqs.com/webtech/062899-1.shtml

or here

http://www.aspfaq.com/show.asp?id=2120

Andrew,

long time no see

Do a search on the MS site. I haven't got the link at hand now, however there are some nice...

Have a look here

http://www.sommarskog.se/dynamic_sql.html

http://www.sommarskog.se/dyn-search.html