I have additional colums with Caluculations, plz chk

CREATE TABLE [dbo].[Table1](

[EmpNo] [int] NULL,

[EmpName] [nchar](10) NULL,

[DeptName] [nchar](10) NULL,

[Location] [nchar](10) NULL,

[AmountPaid] [int] NULL,

[FederalTax] [int] NULL,

[CountyTax] [int] NULL,

[PropertyRatio] [int] NULL,

[Deductable] [int] NULL,

[TaxCode] [nchar](10) NULL

)...

• This reply was modified 2 years, 10 months ago by  mansoorabid.

Thnk u, this resolved my issue

Yes, table2 already has data.

Table2 EmpNo is a PK with INT datatype and also has identity seed.

I want a insert into select Query(EmpName, Dept, Loc) where I can get all...