Excellent, that makes perfect sense!  Thank you!

Thanks, Steve.  I think I was able to come up with something that will work, but I don't know if it's the right way to do it.

Update TABLE1

set 

FIELD1 =

 a.FIELD1...

I understand that I can use one SET as follows:

   UPDATE TABLE1

   SET FIELD1 = 'ABC',

   FIELD2 = '123'

   WHERE ID = '555';

The question I still have is that my values are dynamic based on...

Great, thanks!

I ran the query and 2 out of 5 times it returns different results.  What would that suggest, if anything important at all?

The way the application queries the system...

Thanks for the grammatical correction.

Pardon while I learn the appropriate terminology.  I want to be notified when a blocking or deadlock occur.

Thanks

Thanks for the post.  Here's the output:

Standard Edition 8.00.818

the CUSTNO index on Table1 is Unique and clustered.

the CUSTNO, STATE, ZIP index on Table2 is Unique and clustered (although not a great...

Thanks to all three of you for posting so quickly!  I appreciate it!

Thank you, that makes sense!  I got it to work using

isnull(b.LocationID, ' ') = isnull(b.LocationID, ' ')

Thank you very much for the suggestions!  If I went the route of dynamic sql, how would I deal with single quotes within the quotes?  Such as:

@sql =...

Thanks!  I was actually able to install xp_smtp_SendMail and got it working.  The other way just would not work and keeping Outlook open to send an email is not something...

I don't assume this is specific to a SQL problem, but maybe someone can help.  When I execute this command exactly as it looks (except with my valid info), the...

Thank you Vladan and Scott.  I really appreciate the help.  This definitely gives me something to get me going in the right direction. 

Have a good one!

Thank you all for the replies.  All very understandable and appreciated!

Quick question:  If I wanted to create an Extended SP, it sounds like I need Visual Studio or equivalent.  Does...

Thanks for the multiple suggestions!

There are two reasons. 

First and Foremost, Security:  I've built some very useful SP's that analyze certain aspects of the CRM system.  The clients also have...

Thanks, Mom!  That's exactly what I was hoping for.  I didn't know if editing sysjobs in this fashion was recommended. 

How about if instead of updating them and delete them...