Rekursive SQL Queries – Common Table Expression
Posted in SQL Server on November 2nd, 2009 by Andreas Schwarz
WITH TEMP (Pk, Parent_Pk, Title, Name, Iteration) AS ( SELECT Pk_JobStruct, Fk_Parent, Title, Name, 0 FROM T_JobStruct WHERE PK_JobStruct = 1 -- el cheffe UNION ALL SELECT sub.Pk_Jobstruct, sub.Fk_Parent, sub.Title, sub.Name, (t.Iteration + 1) FROM T_JobStruct AS sub, temp AS t WHERE t.Pk = sub.Fk_Parent ) SELECT * FROM Temp
