General discussion

Locked

Using SQL Triggers to update Tables.

By Sunney ·
I have a table called SALE, which is populated using BCP. The SALE table is missing the Retail Price since it is not in the BCPed file and needs to be read in from another table.

The SALE table has an insert trigger that it uses to populate MONTH_SALE. My question is that can I use this trigger to read the Retail Price in and update the SALE table and simultaneously update the MONTH_SALE table also. Please advise. I thank you for your efforts.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums