SQL Server Recursive CTE A) Simple SQL Server recursive CTE example Weekday declaration: Recursive CTE behaves like an iterator. ELINQ provides Current() method to access the "recursive member". B) Using a SQL Server recursive CTE to query hierarchical data < BACK | HOME