When a new record is updated in a certain table, a small script should be set in motion.
This script looks at two tables and retrieves some information from it.
Based on this information, it updates the records in two tables.
Basically 4 queries which should be launched when the trigger is pulled.
Environment is MSSQL 2005 Enterprise
Remote desktop with Management tools available
An expert has this done in notime.
I've attached a profiler file which explains the behavior a bit.
25 freelancers are bidding on average $57 for this job
Hello Paul - please let me know if the queries that should be called already exist in the DB. Thanks. Chandra
I am expert in MsSQL.I have total 7+ experiance in database management.I will develop your trigger within 3 hours.I have just completed same one project in MySQL
I've placed a low bid in hopes you will try my services. I have confidence in my ability to develop your trigger for the project as stated. My hopes are that you will find my services to be such that you will use me Daha Fazla
Hi I am interested in doing this project. Please see PM.
I have been working on T-SQL queries continuously from past 3 years. I can write any query in very less time.
Hi, Please check PMB for details. Thanks, --Vikas
i can do this in one day.. pls share further details throguh PM
Hi, I have experience working with SQL Server 2005 and would be happy to assist with creating a trigger. Can we discuss in PMB, the attached file does not work.