the following query does not parse:
SELECT CustomerID, PersonID, StoreID
FROM cte
OPTION (MAXRECURSION 2);
see description here:
https://msdn.microsoft.com/en-us/library/ms181714.aspx
The value inside the OPTION is not that important to parse, it is more important not to fail parsing this kind of statements.
the following query does not parse:
SELECT CustomerID, PersonID, StoreID
FROM cte
OPTION (MAXRECURSION 2);
see description here:
https://msdn.microsoft.com/en-us/library/ms181714.aspx
The value inside the OPTION is not that important to parse, it is more important not to fail parsing this kind of statements.