Convert Oracle SQL with Connect by prior to SQL Server SQL

WITH CTE AS
(
    SELECT 1 ID , NULL parentID 
    UNION ALL
    SELECT 2 ID , 1  UNION ALL
    SELECT 3 ID , 1  UNION ALL   
    SELECT 4 ID , 2
)
,CTE1 AS 
(
     Select E.Id, 0 Level              
     From CTE E Where E.parentid IS NULL
     UNION ALL
     Select E.Id, c.Level + 1 
     From CTE E INNER JOIN CTE1 c on c.Id = e.parentid 
)
SELECT COUNT(*) FROM CTE

Select allOpen in new window