Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Adding value from One Table To Another And Update values

Home
Forums

Adding value from One Table To Another And Update values

Sumar Khan

Sumar Khan

10yAsked Feb 26, 2016, 1:16 PM932

I have two tables A and B In Sql:

A

Id Name Weight

1 Wheat 20 kg

2 Rice 30Kg

B

Name Weight

Wheat 10kg

I want to Add value of Wheat from Table A to B and update values according Like that

After Adding 20kg in B The value of Wheat In Table B would become 30kg and Value of Wheat in A become 0...

Plz Kindly tell me What query Will apply in Sql to such Scenario

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Merajuddin Ansari10y ago
try this

use yourDB
go
alter procedure dbo.proc_grain
@name varchar(20),
@weight int
as
declare @aWeight int, @bWeight int
select @aWeight=weight from A where name=@name
select @bWeight=weight from B where name=@name
if @aWeight>0
begin
update A set weight=(@aWeight-@weight) where name=@name
update B set weight=(@bWeight+@weight) where name=@name
end
Manas Mohapatra10y ago
Try with below code:
-- Update table B with total weight
update b
set b.Weight = (b.Weight + temp.Total)
from B b inner join
(select Name, SUM(Weight) Total
from A group by Name)
AS temp
on b.Name = temp.Name;

-- Update table A with 0
update a
set a.Weight = 0
from A a inner join B b
on b.Name = a.Name