Helpful article. I had thought about using a share to back up before, but this article has made me start looking into it finally (while I have the time as...

sp_msforeachdb accepts parameters as well, there's no need for your own cursor.

This would work:exec sp_msforeachdb 'USE [?];

IF DB_ID(''?'') != 2 BEGIN
  SELECT ''[?]''...

Could you not just have the value as a computed column, then there is no need to update, as it's calculated? For example:
USE DevTestDB;
GO

CREATE TABLE Dates...

You're not using the CTE as it was intended. it''s there to  build you a real table you can do a proper join on, as your data is truly relational.

Now looking at the post here Luis has given you the answer you need. You need the use the CTE he gave you. I just tried it, and it worked...

This is something you were asked to do last time, I have done it for you this time, but PLEASE provide CREATE and INSERT statements when asking questions. Considering that...