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