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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-22 : 23:09:31
|
Darioush writes "Here's my setup:
I have 3 tables:
One called Courses, One called Modules and one called CoursesModules.
The first 2 are related through the last one.
So a Course can have many Modules.
Each Module has a price. The combined price of all the Modules of a Course make up the Price of the Course which is stored in the Course Table for easy access.
I would like to write a Trigger on the Modules table for Inserts, Updates & Deletes so that when the Modules table is modified the price for the particular Course is updated.
Sounds Simple but it's got me Stomped. PLS HELP!!!!
SQL SERVER 7." |
|
|
|
|
|
Updating one tables column with the sum of another related tables columns