Does it work?

Yes, that is using aliases everywhere the tables are referenced.

The syntax is incorrect because you have aliased both tables used in the query, but then still reference the original table names everywhere except in the join between sn and...

Dealing just w/ the question of updating, and not recovering space:

If you are updating all rows, can't you just drop the column and re-add (wondering if/why you still need the...

https://github.com/OpenQueryStore/OpenQueryStore

https://dbafromthecold.com/2017/08/19/query-store-functionality-in-earlier-versions-of-sql-server/

(Haven't tried it, not endorsing -- just stumbled across this recently)

You will probably want to use LEAD windowing function. -- e.g.,

DATEADD(day,-1,LEAD(EffectiveDate ) OVER (PARTITION BY PartNum ORDER BY EffectiveDate))

-- Assumes RevisionNum is correctly determined in order...

Why do you want to use dynamic SQL? Why not a procedure specific for each table? How many tables are you archiving?

You can't make either a procedure or a job...

Deleted

I see a fixed font and formatting tools have disappeared completely

But it seems like MSSQL is doing something quite different

What specifically are you seeing for input vs. output?

If you are trying to connect the trace file which SQL Server is currently writing to, you will get "Access is denied" because the file is locked.

Erland Sommarskog, SQL Server...

Unless you have a powerful server, I suspect "loads all the tables data into memory" may be a problem. You may be better off exporting the data to flat files,...

SSMS doesn't know you want to exclude copy-only backups when you are doing a restore using the GUI. It is allowable/valid to restore a copy-only backup. It might be nice...

Use DelimitedSplitN4K, instead

I started to suggest STRING_SPLIT until I noticed 2014. Definitely DelimitedSplitN4K over that loop.

krypto69: Is that function call only used once for a title, or are you using...

Google Search returned a couple of posts indicating it seemed to be SSRS error.

Check the install log files for details in cases of install errors. You might find more information...

No, don't mess w/ the system table.

Just use your own table, function, or hard-coded case statement for Creole -- or other unsupported languages (don't use a comma-delimited list -- use...