title: Copy Row and its children and its children
body: <p>This is similar to this question <a href="https://stackoverflow.com/questions/6767066/copy-row-and-all-of-its-children">Copy Row and all of its 'children'</a> but is a little (maybe a lot) more complicated.</p>
  
  <p>I have a table  'Project' which contains some information and UUID. This has a 1:M relationship with table 'Checkpoint'. 'Checkpoint' then has a 1:M relationship with table 'TaskCommon'. 'TaskCommon' then has a 1:1 relationship with table 'TaskSpecific' which is joined based on its 'TaskCommonId' to it's parent.</p>
  
  <p>I need to create a copy function that will take a project, copy it, then all of its checkpoints, tasks, and specifics.</p>
  
  <p>I plan on using a stored procedure to do all of this and was wondering if there is a better way to do this rather than having to loop through each Checkpoint and then Task.</p>
  
  <p>Is there a way some type of recursive query could be done for this? </p>