February 2012

Last time, we discussed three methods for inserting data into a destination table that has a recursive relationship.  In this article we’re going to cover how to insert data into that table without vi0lating the foreign key constraint by using a WHILE EXISTS loop. If you want to follow along with the examples, you’re going…

Read More Loading Hierarchical Data Using a WHILE EXISTS