Create a trigger to record values from inserted and deleted tables into a "trace" table.

Something like this:

Create trigger ....

for update

As

Insert into BATCHJOBHISTORY_ALERTSPROCESSED_trace

(TraceTime, ALERTSPROCESSED_old, ALERTSPROCESSED_new, pk_col)

Select GETDATE(), d.ALERTSPROCESSED,...

Grant and Jason, can you point to that thing in the execution plan which suggests there is at least one nested view in the picture?

Another case where the function does not do what I'd expect it to do:

DECLARE @Text NVARCHAR(max), @Delimiter NVARCHAR (10), @Quote NCHAR (1)
DECLARE

2 important points.

The holiday table in the article misses a crucial column:

RuleID, or PatternID, or SetID, or TypeID, or whatever name you use to define different patterns of holidays.

Even...

There is a little problem with "quoted split" function (the one I spotted so far) - it does not handle "spaces only" strings well. 
It returns NULLs instead. Even even empty...

Hey, Google, what was that I was about to google?

I gave an example in the post above.

Recognising buyer names in suppliers' data feeds.

If done wrong - invoices generated for wrong customers, processed according to inappropriate rules in a wrong...

Must be a fascinating technical thing which is absolutely useless for actual users.
May be even worse - damaging for real life applications.

In no way I'm critisizing the...