Need a sql script to perform a deep copy of a couple of tables.
Budget: $30 – $250 USD
I need a small script to perform a 'deep copy' and mapping of source records to destination records. There are not a lot of columns to go on. I have attached a small spec. I would prefer that this not run as a cursor. It will be run on the SQL Server platform. Do not add any columns to the tables. You may use table vars or joins to select the data as desired.
The value is in the mapping. I have a script that performs the copies, but I cannot map the data properly to only SELECT the data I want without a strange type of cross join on the child ids.
DO NOT SUGGEST ANY SCHEMA CHANGES!
The value is in the mapping. I have a script that performs the copies, but I cannot map the data properly to only SELECT the data I want without a strange type of cross join on the child ids.
DO NOT SUGGEST ANY SCHEMA CHANGES!