Create an ActiveX task and simply set the variables to zero/blank depending on the data types.

Sales truely is a more profitable profession. In fact, it is the most profitable profession, plus you are in total control of your income. It also does not...

How 'bout posting the error so we can help you?

There isn't anything else I know better that pays more! You see, all I am trying to do is make as much money as possible here and leave this place!...

So what was the waittype of your self-blocked process?

ksullivan is correct, you must alias the table in order to qualify the column names.

As a side note, I hope your servers and customers tables are not huge....

You'll need to work with using dynamic SQL to make that work properly. But beware, there are some things to consider when working with dynamic SQL. Here's a...

A process shows up as blocking itself when it is waiting on resources (usually I/O). Take a look at the lastwaittype from sysprocesses for that spid and it will...

The advantage of using stored procedures is that SQL Server keeps the execution plan in cache so that subsequent executions of that SP do not require a recompilation, in theory....

Why are they not including the transaction when executing? You may want to have them run the BEGIN TRAN and the UPDATE without the COMMIT/ROLLBACK. Once they verify...

Have you went through all of the new formatting/style settings in Management Studios?

What features are you looking for? If all you want is intellisense, use SQL Prompt as G2 suggested.

Are you saying that having Management Studios open bogs down...

Something is very wrong here.

When both id's are found the code does not work. SQL Server showed an error when both conditions were true. So the code did...

What's wrong with using Management Studios for your T-SQL coding?

I think it's worth noting here that what you see happening in Matt's example, is that for the OUTER JOIN, if you reference the outer table in the WHERE clause,...