WITH CTE AS
(

SELECT CAST(1 AS varchar(10)) VAL,CAST(” AS VARCHAR(8000)) COL
UNION ALL
SELECT CAST((VAL+1) AS VARCHAR(10)),COL+VAL FROM CTE
WHERE VAL<=10
)

SELECT * FROM CTE

Advertisements