So they think they overthrow data modeling standards???

I wouldn't like to be in your position right now... I hope this is the only sample of this problem you'll find...

DOD > Dead on Dear Vladan .

Nice to learn that... and I would expect it to perform slightly better than my version .

I don't know if this is acceptable performance wise in your case but it prints total on the last line

Select

...

You can do sum(sum))

You need to put the first sum in a derived table, and then redo another sum on that.

Well I'm out of ideas.  Please tell us when you find something.

That's the power of information .

Very interesting question... can you tell us what the function is doing?

I could understand a very small difference but 10 times faster!!

There's a way to do it but why do you want to do it?  Do you have an obligation to have that number in sequential order or you just think...

too much coffee this morning ??

As far as I understand, the Bin value doesn't need to be returned.  It needs to be converted to HEX, nothing more, nothing less.

Ya and at least 3-4 other small threads of a few messages.

I don't know about the tuning advisor, but in query analyser, if you show the execution plan, then the trigger's plan will be included as well.

However I'd also look at...

Why the heck does he have access to the PRODUCTION TABLES ?

Just curious.  Can you run both version (even on another server) and tell us which one is the fastest?