Link to home
Start Free TrialLog in
Avatar of tommym121
tommym121Flag for Canada

asked on

SQL - how to repeatedly insert records into a table

Select * into #temp1 from T1

Select * into #temp1 from T1 -- This complain the database object 'Temp1' already existed


How can I keep adding record to the table #temp1
SOLUTION
Avatar of hafeezmca
hafeezmca
Flag of United Arab Emirates image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Select * into #temp1 from T1
go 400
this command is repeated 400 times
Avatar of tommym121

ASKER

Thanks for the information