How do you update a table with another tables data. 1

[bloko]

I need help updating an old table data to a new table. the field sare the same for both tables shown below and the table names are SRW_Incident and SRW_Incident2. I have tried a couple of things but nothing seems to work. Any help would be appriciated. Thanks

Incident_No int Unchecked (pk)
Component_Serial_No char(25) Checked
Part_No char(30) Unchecked
Part_Description char(50) Unchecked
Charge_To char(50) Checked
Raised_by_Person_Dept char(50) Unchecked
Order_No char(30) Unchecked
Date smalldatetime Unchecked
Batch_Qty smallint Unchecked
Qty_Affected smallint Unchecked
Raised_By_Dept char(50) Checked
Raised_By_Person char(30) Checked
Hrs_on_Operation real Checked
Heat_Treatment char(3) Checked
Operation_No varchar(50) Checked
Operator_Stamp_No char(4) Checked
Machine_ID char(30) Checked
GRN_No varchar(20) Checked
Raw_Materials_ID char(30) Checked
Supplier char(30) Checked
Feature_Code char(50) Unchecked
Defect_Code char(50) Unchecked
Attribute_Code char(50) Unchecked
Description_Of_Incident char(500) Unchecked
Cause_Of_Incident char(500) Checked
Decision char(20) Unchecked
Completed bit Unchecked
SDR_Exists char(10) Checked
Value_Stream char(30) Checked

 

[simian336]

Please clarify what you want to do. You have an original table and you just want to duplicate that table to with anouther name?

Or you have two tables and you need to move data from one to the other?

Simi

 

[bloko]

Hi Simi,

I have 1 table and I need to create a 2nd table with the 1st tables data.

Thanks

 

[simian336]

select *
Into SRW_Incident2
from SRW_Incident


Simi

 

[bloko]

Thanks, much appreciated