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
45 freelancers are bidding on average $332 for this job
Can do. I have attached a concern though, as your definition seems incomplete. We will have to clear this up before starting. Note: I am using the 2008 R2 version.