Yes... instead of using the "-o somefilename" parameter, use the DOS "redirect as append" characters ">> somefilename".

Sorry Vandy... I just can't read minds today... what's not right about the total sum?

Vandy... how about telling us which columns the +ive and =ive numbers are stored in?  If they are both in the InvoicedValue column, then Marino's should have done the trick...

Better make sure you do a backup before you truncate the log or you won't be able to recover to a point in time which is the purpose of Full...

Sure... what's the Primary Key of the person table?

Maybe this weekend... right now, I'm still sucking my thumb wonder what the heck I was thinking

I'll say... as for me, I can't find the examples I had made for something else (might not even be the same problem ...

Outstanding... thank you for the feedback.

Ok... first things first...

Rob... I'm confused... I thought you were saying that some sproc OUTSIDE of the trigger was being rolled back and that you need what was happening inside...

The only way to keep from rolling back the record inserted by the trigger, is to do it with another connection. 

SP_OA could be used to create such a connection...

...and, still, if you have FULL RECOVERY set, none of that will help the LOG file because all of the updates will be recorded whether they be single updates, batches,...

JUST in case you need it as a single query (In the absence of CTE's, I do like the temp table solution better which is why I didn't answer previously...

Yes, it does make sense... What I'd recommend is writing a script that would populate a working table (permanent table that will last until this problem is resolved and then...

The update isn't really ignored if there's no match... it just doesn't update anything although it is executed.

Try adding the -c parameter.  If that doesn't do it for you, add the -C parameter with the proper code page (see Books Online for the proper code page.)  Do...