Copying Data from one table to another Sql Server 2005
Posted on 2009-07-08
I've got a table "Labor" that has existing employees hours in it. I have created another table called "LaborReport" that needs to have all the data existing in Labor transfered to it. It has all the same columns, minus it's own unique identifying column.
The columns in Labor are:
The columns in LaborReport except it has an added column called "ID"
What's the easiest way to get all the data from one to the other? Is there a query I could write that would do it?
Also this only needs to be a one time transfer, I have the triggers that will keep the two tables the same after I can get all the existing data in there already.
While I'm very famliar with coding and accessing data in a database, I'm really novice when it comes to doing things inside a database.. so I'm assuming there has to be an easy way to do this rather than having to code a function to loop through and grab all the records, store the data in variables, then do an insert into the new table....