If you want to create a vertical menu that scrolls through the items as you scrolls through the page
Let us say we have 2 tables that are in a parent-child relation.
We want to make a copy of the FormSectionInstance rows, but also copy and correlate the FormDetails rows.
This means copy rows from 2 tables and then set them up with the correct NEW corresponding IDs.
We could use a cursor, but a better alternative is the the MERGE INTO function.
We also create a TEMP transition table to hold the new VS old values. We use these values when we insert the CHILD values.
This way we can make the INSERT faster.
This solution is usefull when you want to debug on multiple environments.
Just add ad template file, some transformation config files and then select your desired Solution configuration.
Web config will be changed on the spot.
Also usefull when you want to publish on different environments.
You can setup different web.cofig configurations.