¡@
c# Programming Glossary: lvlSimulating CTE recursion in C# http://stackoverflow.com/questions/6225123/simulating-cte-recursion-in-c-sharp and performance WITH hierarchy_cte id parent_id data lvl AS SELECT id parent_id data 0 AS lvl FROM dbo.hierarchical_table.. id parent_id data lvl AS SELECT id parent_id data 0 AS lvl FROM dbo.hierarchical_table WHERE parent_id IS NULL UNION ALL.. IS NULL UNION ALL SELECT t1.id t1.parent_id t1.data h.lvl 1 AS lvl FROM dbo.hierarchical_table AS t1 INNER JOIN hierarchy_cte..
|