Ransom

(Truly today's, may be not so random)

Jeff, I'd prefer to use ' [' instead of '[' as a split point.

It's more definitive, and leaves no trailing spaces.

But it requires some degree of consistency in string formatting.

Are there other indexes on the table, apart of the non clustered on Date?

You need to normalise the data.

You can do it in 2 steps:
1. Using Splitter8k function (see the article from Jeff Moden on this site) split the comma...

Your code works for me.

Here isd what I see on Messages ta

(0 row(s) affected)
4
Msg 50000, Level 16, State 1, Line 24
Divide...

Make a dynamic script which create functions named, say, {Table 1}_Formula_{Key} based on the script saved against each key.
Put it into a job with no schedule.
Test it by...

Your case only indicates that DECIMAL data type does not have sufficient precision to correctly represent FLOAT values.

Yes, a number loses precision when converted from FLOAT to DECIMAL.

Considering that...

Can you trace the DB calls?

But honestly - if you cannot change the code there is no hope to fix it.

The issue is within the code.

There must be an explicit...

Is "Approval" the only thing which happens to the travels?
Do they get cancelled, rescheduled, etc.?
Such events related to travels must be recorded in a separate TravelEventLog table with...

Where does 

come from?
A SELECT query does not initiate any "U" kind of locks by itself.
What causes "update resource lock" to be placed within this transaction?

This should be easy to understand while doing the trick:

select
   R.TxnID
   , ISNULL(ATotal, 0)ATotal
   , ISNULL(PTotal,0) PTotal
   ,...