Your 1st query uses 2015/09/30 in the where clause and your 2nd has no mention...

I did it this way:

SELECT
A.ProductCode,
CASE A.FranchiseCode
WHEN ''
THEN B.FranchiseCode
ELSE A.FranchiseCode END AS FranchiseCode

FROM...

Why? If the CTE works, why not use it?

You can do the same thing with...

Why? If the CTE works, why not use it?

You can do the same thing with...

If you're intepreting NULL as 0, then:

SELECT COALESCE(col1,0) + COALESCE(col2,0) + ......

Yes, and if you do update the table so that there are no more...