;WITH NumberTable (N)
AS
(
SELECT 1
UNION ALL
SELECT N+1
FROM NumberTable
WHERE N+1 <=300
)

INSERT PERSON (Name)
SELECT  'Person' + CAST(N AS varchar(3))
FROM NumberTable

quote:

---

Originally posted by visakh16

;WITH NumberTable (N)
AS
(
SELECT 1
UNION ALL
SELECT N+1
FROM NumberTable
WHERE N+1 <=300
)

INSERT PERSON (Name)
SELECT  'Person' + CAST(N AS varchar(3))
FROM NumberTable

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

quote:

---

Originally posted by visakh16

;WITH NumberTable (N)
AS
(
SELECT 1
UNION ALL
SELECT N+1
FROM NumberTable
WHERE N+1 <=300
)

INSERT PERSON (Name)
SELECT  'Person' + CAST(N AS varchar(3))
FROM NumberTable

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

.....
SELECT  'Person' + CAST(N AS varchar(3))
FROM NumberTable
OPTION (MAXRECURSION 300);