arhame
asked on
Copying Data from one table to another Sql Server 2005
Good afternoon,
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:
LaborId
JobId
EmployeeId
LaborDate
LaborHoursWorked
EmployeeRoleId
TimeTypeId
LaborNotes
LaborPeriodFrom
LaborPeriodTo
CreatedBy
CreatedDt
UpdatedBy
UpdatedDt
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....
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:
LaborId
JobId
EmployeeId
LaborDate
LaborHoursWorked
EmployeeRoleId
TimeTypeId
LaborNotes
LaborPeriodFrom
LaborPeriodTo
CreatedBy
CreatedDt
UpdatedBy
UpdatedDt
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....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
They are the same, except that LaborReport has it's own UniqueID column, and just stores LaborID (the unique ID on the main table) as an int. Having the Unique ID's match isn't so important as just having the value there to access if I need it.
Let me log in and try that statement I'll be right back.
Let me log in and try that statement I'll be right back.
ASKER
Perfect and fast, thanks for your time :)
No problem!
Hope that helps.
P.