Update foreign key table record based on primary key table id in SQL Server

Hi SUJAYS,

As per your Query i have create the sample.If you have any doubt Please revert me back.Below is the given sample

SQL

DECLARE @Tax TABLE
(
Rate INT
,Taxper INT
)

INSERT INTO @Tax VALUES(1000,12)
INSERT INTO @Tax VALUES(10000,12)
INSERT INTO @Tax VALUES(900,12)
INSERT INTO @Tax VALUES(1200,12)
INSERT INTO @Tax VALUES(700,12)
INSERT INTO @Tax VALUES(11000,12)

UPDATE @Tax 
SET Taxper = 5
WHERE Rate BETWEEN 1000 AND 10000

SELECT * FROM @Tax

Output

Hi Zameer

    I have two table as Table 1 and Table 2

Table1

Table 2

How to update table 2 based on Table 1 based on Itemid and Prodid?

Is there any relation between between these two tables.

The relation between two table is Itemid and Billid which is same...

Hi SUJAYS,

I have create the sample .If you have any doubt revert me 

Below is the sample.

SQL

DECLARE @TABLE1 TABLE
(
BillId INT
,Prodid INT
,Saleper INT
,Dates DATETIME
)

INSERT INTO @TABLE1 VALUES(1,1001, 5,'11-2-2017')
INSERT INTO @TABLE1 VALUES(2,1002, 4,'11-1-2017')
INSERT INTO @TABLE1 VALUES(3,1003, 7,'11-3-2017')


DECLARE @TABLE2 TABLE
(
Itemid INT
,Taxper INT
,hsncode VARCHAR(100)
,Taxperid INT
)

INSERT INTO @TABLE2 VALUES(1001,4, 'sdsd3434',1)
INSERT INTO @TABLE2 VALUES(1002,12, 'fdfd34343',2)

UPDATE t2
SET Taxper=5
FROM @TABLE2 t2
 INNER JOIN @TABLE1 t1
ON t2.Itemid = t1.Prodid

SELECT * FROM @TABLE2

Output