Recursive CTE With UNION gives error
why can’t we use , just “UNION” instead of “UNION ALL” in the recursive CTE’s. If I use just UNION in the recursive CTE it is throwing error. Can you please help me out?     Example,                     CREATE TABLE te (sno int) Go INSERT INTO te VALUES (1),(4),(10) Go ;WITH ctemax(maxsno,minsno) AS [...]

Answer Question   |  July 23, 2012  12:37 PM
CTE in SQL server 2008