Loading Hierarchical Data Using a WHILE EXISTS

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… Continue reading Loading Hierarchical Data Using a WHILE EXISTS

Loading Hierarchical Data

Earlier this week the question came  up on how can we insert data into a table that has a hierarchical data structure.  If you’re not familiar with a hierarchical data structures, here’s a quick explanation. Consider the staging table to the right.  This table is used to load new accounts into our system.  Each account… Continue reading Loading Hierarchical Data