I hope the above is what you were asking for.

I'm not sure how to proceed with the CTE or how to get the previous unique id(s)).

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#table1','U') IS NOT NULL

DROP TABLE #table1

--===== Create...

Thank you all for your replies! As soon as I get time, I will read the links Corgi posted and read about a CTE.

Our office uses templates (forms). ...

Thank you for your reply. I can't add columns to the tables 🙁

Table1

551PopulateYNULL234BF3838A-1795-451F-858B-781061EC2F79

551PopulateYNULL23A37F7A46-90EE-4DAA-9ADA-2B698E191389

551PopulateYNULL23B6B97508-3174-4583-85E5-69877FEBBE2B

551Edit YNULL23"Hell World"

551ActionYNULL23"Print report"

551PopulateYNULL23"Some Data"

Table2

5514BF3838A-1795-451F-858B-781061EC2F79test_lisa {@DP}0

5514BF3838A-1795-451F-858B-781061EC2F79test_sam 0

5514BF3838A-1795-451F-858B-781061EC2F79test_joe90

5514BF3838A-1795-451F-858B-781061EC2F79test_al10

5514BF3838A-1795-451F-858B-781061EC2F79test_al20

5514BF3838A-1795-451F-858B-781061EC2F79{@This}80

551A37F7A46-90EE-4DAA-9ADA-2B698E191389test_al_c10

551A37F7A46-90EE-4DAA-9ADA-2B698E191389test_lisa_s ...