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

Question

Table1rateTax Per100012Table2FromRateToRateTax1000100005 I have two tables like thisI want to update all the rows like I want to update the first table based on second table as values above 1000 or  equal to 1000 want to updated as 5 How to update this table

zameer · Accepted Answer

Hi SUJAYSI have create the sample If you have any doubt revert me Below is the sampleSQLDECLARE TABLE1 TABLEBillId INTProdid INTSaleper INTDates DATETIMEINSERT INTO TABLE1 VALUES11001 539112201739INSERT INTO TABLE1 VALUES21002 439111201739INSERT INTO TABLE1 VALUES31003 739113201739DECLARE TABLE2 TABLEItemid INTTaxper INThsncode VARCHAR100Taxperid INTINSERT INTO TABLE2 VALUES10014 39sdsd3434391INSERT INTO TABLE2 VALUES100212 39fdfd34343392UPDATE t2SET Taxper5FROM TABLE2 t2 INNER JOIN TABLE1 t1ON t2Itemid  t1ProdidSELECT  FROM TABLE2OutputItemidTaxperhsncodeTaxperid10015sdsd3434110025fdfd343432

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

Company

Explore

Follow us

Contact Us

rate	Tax Per
1000	12

FromRate	ToRate	Tax
1000	10000	5