This is really beginning to frustrate me.

IF OBJECT_ID(N'dbo.mtzcus_2014_CoreMenuAuditDetails', N'U') IS NOT NULL

AND EXISTS ( SELECT TOP 1

...

I was hoping to avoid that, but ya gotta do what ya gotta do.

Thanks Gail,

~ Jeff

The script is used to deploy code and data objects to our customers, and contains several objects entirely contained within a TRY/CATCH block. The script is designed to be run...

I found a MS reference that states:

"DROP TABLE and CREATE TABLE should not be executed on the same table in the same batch. Otherwise an unexpected error may occur."

and also:

"A...

Thanks for replying; I now have a situation where there are four possibilities:

1) ISNULL

2) COALESCE

3) COALESCE with CAST/CONVERT

4) Modify the column from SMALLINT to INT

I've run each of the three...

Another great reply; I currently ask my team to use COALESCE exclusively because it's ANSI standard and more flexible due to multiple parameters...but your reply leads me back to "any...

Thanks all for replying; although I was aware of the "precedence" feature of COALESCE, I didn't realize that literal values would be typed differently, in this case 99 as an...

Thanks for replying...and my wife agrees with you.

~ Jeff

Thanks for the query, I appreciate you letting me utilize the results of your efforts.

~ Jeff

Thanks for the replies...I'll try out each and see what suits the situation best (or what I can actually manage to get working!)

~ Jeff

Thanks for replying, I also didn't think about temp tables. Always great (and useful) replies on this site...my top "must read".

~ Jeff

Thanks for replying...unfortunately, this is vendor-supplied software, so we can only affect performance by changing db options/parameters, indexing, etc.

~ Jeff

Thanks for replying; more info to add to my growing (yet still horribly inadequate) knowledge base.

Upon further digging, I've also come across a large number like this:

CREATE PROCEDURE nl_storage_items_update_items

@wstrListName nvarchar(256)

AS...

Thanks, I'm always interested to learn more about the product and its inner workings.

~ Jeff

Thanks for replying and the info. I'll increase the log file as you've suggested.

~ Jeff