Wait a minute!  If you have a default on the column and you don't insert anything into it, then the column will have the default after an insert... why would...

Like I said, that takes care of existing data... whatcha gonna do for new data that enters into the table? 

Evan,

You mentioned "PL/SQL"... as you know, the SQL extensions between Oracle and SQL Server are quite different.  Are you looking for an Oracle (PL/SQL) solution or an SQL Server (T-SQL)...

What is the default value?  That's what you have to put in the function.  It can be a column name, another variable of the same or implicitly convertable type, or...

Peter's method is absolutely a great way to take care of existing data.  The problem is, wadaya gonna do with new data?

If you really need to do such a thing,...

Lynn,

Too bad about that person.  We've still got one like that, too.  Dunno why they keep him around.

Say, that 3rd party app wouldn't happen to be a product called "Cost...

Spot-on on all points, Matt.  And, thanks for the reminder... I forgot that such tools just short office politics right straight to ground.

Lynn,

Sorry, got a bit distracted... I think your co-worker is spending way too much time monitoring performance.  HOWEVER, I've not had to walk in his/her shoes... it may be that...

Pet peeve... maybe a rant... (please forgive the forthcoming soapbox)... consider this carefully... no matter which "performance monitoring" tool you use, what good does it do you if you find a...

I am unable to duplicate the failure you say you are experiencing... that's not to say it's not happening... I just can't duplicate it because I don't have your data.

My...

Yes... it works fine... if you are only updating one row at a time... try updating more than one row at a time and see what happens... BOOOMM!

I'm looking at...

Nope... you made an unqualified statement with no conditions.  And no one would force such an index as you have because everyone knows the bookmarks will kill any hope of...

Dunno about others but I only use DTS for one off, ad hoc copies of data.  If it goes into production, I use either BCP or Bulk Insert.  I don't...

You are missing joins between the PK of the INSERTed and DELETEd tables in all such SELECT's in the code you posted...

Recommend you change them all similar to the following...