SQL Data Relationship

Question

4.00/5 (1 vote)

See more:

I have two columns, Quantity and Value. I want Value to be relational to Quantity in the sense that if quantity goes up its value stays relational to it and also goes up. Any ideas how to do this? (SQL Server 2008)

Posted 12-Dec-11 2:47am

WurmInfinity

Add a Solution

2 solutions

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)

Nikil S · Accepted Answer · 2011-12-12T03:34:00

Solution 1

Try using a TRIGGER[^] to find out if Quantity column is updated using UPDATE[^] and then update the Value column with the new manipulated value accordingly in the trigger.

Posted 12-Dec-11 3:34am

Nikil S

Updated 12-Dec-11 3:35am

Comments

Valery Possoz 12-Dec-11 9:37am

You beat me to it! :) 5!

Nikil S 12-Dec-11 9:49am

Thank you.

Valery Possoz · Accepted Answer · 2011-12-12T03:35:00

Solution 2

Hello,

One way to do this is to use a trigger.

Something like that:

SQL

Create Trigger UpdateData
On Table_1
After Insert, Update
As
Update Table_1 set Value = Quantity * 2;

Each time an update or insert will be performed, the trigger will be called, you can put what ever SQL you fancy in the trigger.

http://msdn.microsoft.com/en-us/library/ms189799.aspx[^]

Valery.

Posted 12-Dec-11 3:35am

Valery Possoz

Updated 12-Dec-11 3:36am

v2

Comments

WurmInfinity 12-Dec-11 9:39am

Yeah that's awesome. Opens up loads of new possibilities too. Thanks a lot! x