Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlbenzo
Starting Member
1 Post |
 Posted - 2005-11-15 : 17:42:24
|
Hi All,I have a very complicated project and for some reason I have decided to use SQL server as the backend database. I am new to it and have encountered my first problem. In basic terms what I want to be able to do is increment/decrement a field in a table according to something that happens in a different table. Where do I start?So for example, a stereo system/cd player can have 10 cds at one particular time, when 2 cds are removed, then 8 slots are available. Then when 1 of the 2 remaining slots are filled then 1 slot remains and so on....so I want some sort of a counter field. Using that field I want to be able to generate a report on what is currently available.Please Excuse my lame example but can anyone please help?ThanksBen |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-15 : 19:22:44
|
| Have a look at triggershttp://www.nigelrivett.netlook at triggersIf all your access is via stored procedures (it should be) then it simple - just put the logic in the stored procs.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Calculating between tables