Monthly Archives: April 2010
Recursive CTE's
First, the problem: You have a table containing some kind of a hierarchy using parent IDs. You have to write some SQL to return all of this data in the hierarchy with each parent and then the child records. One … Continue reading