store value based on two columns

[MartDawg]

I have a table

column1...column2.....column3

column1 is an int

column2 is an int

I want to store column1/column2 in column3 and have it update each time column(1 or 2) updates.

What is the best way to do this? I was thinking a trigger and a stored proc? Is there any way to store that info without a trigger or stored proc?

 

[johnwm]

It's a bit unusual to store a value calculated from two other fields. Normal db practice would be to calculate when you need it, rather than store redundant information. However if you really need to do this then a Trigger and an update query would do it.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller