title: Inserting multiple rows at once when parent-child relationship is in the same table
body: <p>I'm trying to use bulkinsert to insert multip rows at once. </p>
  
  <p>In the data to be inserted, the Parent-Child relationship is determined by the "ParentName" column, a nvarchar type. </p>
  
  <p>But in the data table, the parent-child relationship is determined by ParentId, a uniqueidentifier. </p>
  
  <p>How should I approach this so while inserting, the parentId is the generated id of the child's parent record? </p>
  
  <p>Please let me know if I can clarify my questions further. I'm using sql server 2005.</p>