Recursive CTE Problem
- by Chris
Hi,
I am trying to use a recursive CTE in SQL Server to build up a predicate formula from a table containing the underlying tree structure.
For example, my table looks like:
--------------------------
Id Operator/Val ParentId
--------------------------
1. 'OR' NULL
2. 'AND' 1
3. 'AND' 1
4. '' 2
5. 'a' 4
6. 'alpha' 4
: : :…