how to formulate a table value with another tables column in sql server 2008

Question

0.00/5 (No votes)

See more:

0 Hi,

I have two tables

Stock table and Order Items Table

The Stock Table contains a Sold_Stock field

The Order Items Table contains a quantity field

both tables are linked by an Item_ID (Primary key in the Stock Table and Foreign key in the Order Items Table)

I want to know how to write a formula in Sql Server 2008 on the Sold_Stock field so that whenever a record is inserted into the Order Items Table the quantity field value will get added to the Sold_Stock field in the Stock Table.

I know how to write formulas within a table but i have no idea to reference another table's column. Can anyone please help me out!

Thanks in advance

Mirfath

Posted 23-Nov-12 0:29am

mirfath

Add a Solution

Comments

__TR__ 23-Nov-12 6:47am

You can do this using triggers. This article helps you understand triggers
Triggers -- Sql Server[^]

Corporal Agarn 23-Nov-12 13:51pm

I had the same thought.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

vishal jodh · Answer 1 · 2012-11-24T01:18:00

Solution 1

Trigger is best for this problem

Posted 24-Nov-12 1:18am

vishal jodh