Add an SQL table with a trigger
$30-250 USD
Teslim sırasında ödenir
We have an MIS system where we add jobs with a due date. I want a table created that maintains the original due date, and another column which updates a revised due date. I also want a counter that will track the number of times the due date was changed.
The flow would work something like this...
New job entered and saved-----> Triggers a new record to the due date table --->
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
Due date modified-------> Triggers an update to the revisedduedate and changes the duedatecount to +1, +2, etc...
We go in and out of these job records all the time, so I'm guessing you may need to incorporate some logic so it's not erroneously counting revised due dates everytime someone saves a change.
I think this is a fairly straight forward tweak that can be handled with a stored procedure.
Proje NO: #15153731
Proje hakkında
Seçilen:
Hello, as a MSSQL Server expert, I can easily solve your problem by adding after insert and after update triggers to your duedatetracking table. Feel free to contact me if you are interested. Cheers Relevant Skills an Daha Fazla
Bu iş için 14 freelancer ortalamada $147 teklif veriyor
Hello, As an expert in writing complex sql statements, i am very much interested to do this work. I understand what you need. Just to clarify, what will i do to achieve your need is: create a new trigger for insert/up Daha Fazla
This task is to create a new table and a trigger to manage due dates with revisions. Relevant Skills and Experience I have 9 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET Daha Fazla
My proposal is not to update the due table record but to always create a new one. With that approach you will know the times and keep track of the changes. I will also add the datetime of the change. Relevant Skills a Daha Fazla
Hello Sir, I am a sql server expert and interested in this project. Please open chat to discuss more about this project and my approach. Thanks Aanvik
Greeting, I am the expert freelancer for this job. I can help you to Add an SQL table. Please give me a chance to work on your project. Relevant Skills and Experience I have more than 5 years of experience with excel Daha Fazla
Hi, I can work on sql trigger. Competenze ed esperienze rilevanti I am .net/sql developer. Pietre Miliari proposte $111 USD - task
I'm SENIOR SQL SERVER DBA with many years of experience in MS SQL database specializing in database performance optimization and troubleshooting Will write this as needed from performance perspective. Odpowiednie Umie Daha Fazla
I REVIEWED YOUR PROJECT DETAILS & WOULD LIKE TO OFFER YOU MY SERVICE OF DOING FIRST TASK FOR FREE Relevant Skills and Experience I am Senior Software developer, having 7+ years experience with team of additional 2 dev Daha Fazla
I'm a senior mobile & web providing customized solution in mobile apps and website development having experience since 6+ years. I've vast experiences and latest technologies with my energetic effort. I'm also a flex Daha Fazla
I have 4 years of experience working with MSSQL. Relevant Skills and Experience MSSQL Programming Stay tuned, I'm still working on this proposal.
Are you need a create a table with trigger function? I can do this. Relevant Skills and Experience I am a programmer with 9 years of experience. Proposed Milestones $200 USD - Pay after complete