title: importing data with updated parent-child keys
body: <p>I have a table with this structure:</p>
  
  <pre><code>    [ID] [int] IDENTITY(1,1) NOT NULL,
  
      [ParentID] [int] FOREIGN KEY([ParentID]) REFERENCES [dbo].[tblTask] ([ID])
  
      [Name] [varchar](20)
  </code></pre>
  
  <p>This table is populated. </p>
  
  <p>I need to import data from another similar table, and need the new parent-child relationships to be valid of course. Is there some pre-existing functionality or methodology that I can use?</p>
  
  <p>This is MSSQL 2008</p>