Hello,

I dont know if this is the right forum for this question, but I'll give it a try.
I have created a table in SQL Server - lets call it TempTable in the Temp Database.
I now want to copy all the data from TempTable to LiveTable (both in the Temp db) using
a stored proc - ie T-sql. How do I do this? I want to COPY the data, NOT read (select) thru
each record in Temp and Insert into Live!!

I know there is some command to do this, but forgot what it is.

Thx,
L