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 freelancer bu iş için ortalamada 57$ teklif veriyor
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
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.