I want to copy records of a table say employee into the same table.
For Example Table Employee contains 5 records.
So i want to insert the same 5 records again into the same table Employee 20 times.
I have tried the following Query (which is inserting records in another table) :
DECLARE @intFlag INT
SET @intFlag = 1
WHILE (@intFlag <=20)
SELECT * INTO table2 FROM table1
SET @intFlag = @intFlag + 1
If i am copying records into the same table then
Error is displayed :
There is already an object named table1 in the database