Hi, I got a table from SSIS Transformation stored in SQL Server. It has the combination of Name and its Ref Name with its ID's. Need to split this Table into single row with Parent and Child ID updation.
It wont work. We cant take MIN REFID for Parent and Child Update. Its an example with some fields. For reference I have given some sample Data. Some CIID will refer 4 or 5 ID's and Some ID will refer only one.