Skanda (10/8/2012)

---

Hi,

not exactly like home work, as per my requirement only am posting.

i've tried below code, but it is generating only number.

WITH Sequence ( SeqNo) as

(

SELECT 1

UNION ALL

SELECT SeqNo + 1

FROM Sequence

WHERE SeqNo < 1000

)

SELECT TOP 1000 * FROM Sequence

OPTION ( MAXRECURSION 0);

GO

please help me......