SQL Trigger - Compare and Edit

This project was successfully completed by Dusan74 for $250 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$250 - $750 USD
Completed In
1 day
Total Bids
Project Description

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 need

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online