SQL Trigger - Compare and Edit
- Status Completed
- Budget $250 - $750 USD
- Total Bids 45
I require a trigger based on the attached DB file that will AFTER INSERT UPDATE WORKOBJ. The trigger should retrieve the AuthorID and Facility from the WORKOBJ inserted and match to the FriendlyID and Facility of the User table. Get the AnaConfGroup for that user and find it in Name of the AnaConf table.
At that point the trigger would need to check the following fields in the WORKOBJ and if they have "0" or blank and the same field is not "0" or blank in the AnaConf then modify WHERE [url removed, login to view] = [url removed, login to view]
This may be difficult to explain so please ask any questions you needGet free quotes for a project like this
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online