SQL Trigger - Compare and Edit

  • Status Completed
  • Budget $250 - $750 USD
  • Total Bids 45

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

Get free quotes for a project like this
Completed by:
Skills Required

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