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 |
|
nutpuk
Starting Member
3 Posts |
 Posted - 2004-08-19 : 05:15:29
|
| Hi again. Just thought Id ask this question I need to create a trigger to reduce the quantity in stock when a part appears in the invoice line, Ive tried loads of things only to get error after error The tables which i need to use in the trigger are these:I have an invoice line table which has these fields: Invoicenumber, Date, PartNumberAnd a Part Table with these fields: PartNumber, qtyinstock, minstock, description I need a trigger to reduce the number in stock on the part table when the part number appers in the invoice table, hope you get meAny help or bits of Trigger statements would really help. |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-08-19 : 07:18:43
|
| Note: Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38828 |
 |
|
|
|
|
|
Trigger HELP