SQL Trigger - Compare and Edit

Closed

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

Skills: SQL

See more: update sql file, sql retrieve table, compare update, update insert sql, update field sql field field, insert sql, check compare, sql trigger update, check edit, sql questions, check sql, edit name, sql insert insert, sql update fields, sql table field, sql match, modify fields sql, match sql, update file sql, sql insert file, compare file, sql insert, update sql table file, compare file file, sql insert file field

Project ID: #4742608

Awarded to:

Dusan74

Hi, I am SQL developer with 10+ years of experience. Details of implementation are in PMB. Thanks!

$250 USD in 1 day
(4 Reviews)
2.5

45 freelancers are bidding on average $332 for this job

hits

We are a team of developers with expertise and experience in SQL and we have written many complex triggers / queries as part of the complex and extensive applications coded by us. I have read the requirements and have More

$368 USD in 5 days
(91 Reviews)
7.0
siberiangirl

Hello, What SQL Server version do you use? Regards

$277 USD in 3 days
(106 Reviews)
5.8
feninsoftech

Hi, Since last 8.5 years, i am extensively using SQL Server, C# and ASP.NET. Expertise in writing Stored Procedures, Joins, Triggers, Indexing and Performance Optimization. Microsoft Certified Technology Speci More

$277 USD in 10 days
(8 Reviews)
4.4
rakib062

Please check private message.

$250 USD in 3 days
(7 Reviews)
3.5
Reza2012

Hi I have more than nine years experience in SQL Database Administration and PL/SQL Programming. Please see PM. Thanks

$366 USD in 7 days
(4 Reviews)
3.5
nikesolutions

I'm experienced enough in MS SQL. I'm sure I can help you for this task.

$250 USD in 1 day
(1 Review)
3.2
diegofpr

Hi, I have more than 12 years experience in database design & programming. I am more than used to handle triggers, both in Oracle and SQL Server databases. I think I have understood clearly the idea of the explanatio More

$300 USD in 1 day
(1 Review)
3.0
sswijaya

Hi let me help you with this project.

$250 USD in 3 days
(2 Reviews)
2.8
pablotorres

I can do it

$250 USD in 14 days
(5 Reviews)
2.7
mastersoft1

I have a 5-year expericence with database design. Consider your problem resolved!

$555 USD in 1 day
(3 Reviews)
2.1
FLinCanada

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.

$300 USD in 3 days
(2 Reviews)
1.8
ultrasonicsoft

Hi, Please check your inbox for more details. Thanks!

$277 USD in 5 days
(1 Review)
1.5
AliSafder

Hi, I am expert in writing triggers... I am really looking forward to work on this task. You can pay me once you verify the work.

$250 USD in 3 days
(2 Reviews)
1.2
luki555

Hi. Check your PM please.

$250 USD in 1 day
(1 Review)
1.1
tomianabidpk

i can do this

$555 USD in 3 days
(1 Review)
1.1
elboukharimu

I can help you, please check your Inbox

$250 USD in 3 days
(2 Reviews)
1.0
lornard

Hi Your project description and project requirements are very clear to me, i can handle this project in perfect manner. Best Regards, Lornard.

$277 USD in 3 days
(1 Review)
0.6
mdakteruzzaman

Expert in Database administration more than 9 years . pls check pmb

$250 USD in 4 days
(3 Reviews)
0.2
logoDS761

will achieve this very well for you

$250 USD in 5 days
(0 Reviews)
0.0
shankardeokar

Hi I can work on this project.

$250 USD in 3 days
(0 Reviews)
0.0