sqlparser · April 8, 2014 07:20
diff --git a/common table expression b/common table expression
 WITH mycte(x) AS (SELECT x = Convert( VARCHAR(1000), 'hello' ) 
                  UNION ALL  
                  SELECT Convert( VARCHAR(1000), x + 'a' )  
                  FROM   mycte  
                  WHERE  Len( x ) < 10 
                  UNION ALL  
                  SELECT Convert( VARCHAR(1000), x + 'b' )  
                  FROM   mycte  
                  WHERE  Len( x ) < 10) 
 SELECT x  
 FROM   mycte  
 ORDER  BY Len( x ), 
          x;
	WITH mycte(x) AS (SELECT x = Convert( VARCHAR(1000), 'hello' )
	UNION ALL
	SELECT Convert( VARCHAR(1000), x + 'a' )
	FROM mycte
	WHERE Len( x ) < 10
	UNION ALL
	SELECT Convert( VARCHAR(1000), x + 'b' )
	FROM mycte
	WHERE Len( x ) < 10)
	SELECT x
	FROM mycte
	ORDER BY Len( x ),
	x;