Why is the column in the lookup table NULLable?

Is there actually a NULL value in it?

It's quite possible if you populate it from an Excel range.

Thanks for your feedback. Sadly I have checked all 3 items you mentioned and i have received confirmation that the SAN has not changes, the Server hasnt taken any...

From what I was able to see in the monitoring feature on this site, the problem is in terrible design of both database and the querying processes.

It's msdb all over...

Update a column only when the new value is different from the current one

UPDATE

...

WHERE NOT (SourceTable.Col = TargetTable.Col)

If the column Col allows NULLs make sure you handling them right.

You don't use any field from T0 in the SELECT part, so you better put that table to WHERE EXISTS clause.

And with Jeffrey's suggestion about the subquery, you should get...

That makes sense. What about something like a web form where a new user enters all of their information (name, age, city, state, zip, income, ethnicity, email, etc) for...

To add to what Jeffrey said - if a CTE is mentioned in the following code 2 or more times it's evaluated and executed as many times. No caching and...

That’s the case where everybody wins.

Bad implementation of stupid policy cancels all its disadvantages.

yes, there is still an overhead of all the resources spent on supporting that policy - but...

Time tracking has nothing to do with productivity.

its actually counterproductive. Eventually it leaves the company with those developers who produce best time sheets, not the best product.

imagine a team assigned...

For ReplacmentCode=120 you have  finalcode = NULL

For ReplacmentCode=860 you have  finalcode = 42

Can you explain the difference between these 2 use cases?

Once again, it's not about SQL Server versions, it's about the formatting returned by OS commands.

Which depends on OS versions and locales.

The thing is:

The command EXEC XP_CMDSHELL 'FSUTIL VOLUME DISKFREE E:\' returns the following recordset on my laptop:

Total free bytes : 1,716,875,264 ( 1.6 GB)
Total bytes : 16,503,533,568...

There's one big thing you are missing from your question - What are you trying to accomplish?  Changing the EXISTS clause to a join will cause you to have...

Different OS locales might cause different formatting of the output of "FSUTIL VILUME".

you need to "teach" your script to identify the anchor points in the returned sets of string and...

And also look for OS, emailing, etc. tasks - those must be either completed (success or fail - does not matter) or terminated before the process which initiated them could...