INSERTING MULTIPLE ROWS FROM ANOTHER TABLE

[bgreenhouse]

Hi Everyone

I'm trying to make a SQL Statement that will be a step in a job. What I'm trying to do is insert all the rows in a temporary table into a permanent table that has the exact same structure as the temporary table (just append them on the end I guess). I know how to do this in ASP, I'd just create a recordset of all the fields in the temp table, and then loop through each record, and insert it into the permanent table each loop. Unfortunately, you can't use VBScript in a TSQL step in a job. Any ideas (either a TSQL statement, or an alternative)?

Thanks

Ben

 

[balves]

INSERT perm_table
SELECT * FROM #TempTable

 

[bgreenhouse]

Thanks Balves...I figured that out pretty much right after I posted the question...Must not have had enough coffee this morning...I was trying to put the VALUES part in...

Ben