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-11-20 : 23:45:04
|
scott writes "SQL 7 NT4
Table 1 has fields ID & Amount(Money).
Table 2 has fields ID & TotalAmount(Money).
Table 1 for each ID there can be numerous Amounts, I need to create a trigger that sums all amounts for a given ID then updates Table2.TotalAmount with the summed value for the same ID.
I know the sum value is a varchar therefore need to convert it to money and update in table 2 for same ID." |
|
|
|
|
|
SUM with WHERE in 1 table and UPDATE with WHERE in another TRIGGER