Update trigger with a join

Last Post 23 Dec 2007 12:26 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
timcronin
New Member
New Member

--
05 Dec 2007 08:51 AM
Trigger not firing on update
Reply Quote Delete Edit Favorites Contact I have a master table in a database when updated has to change a location field in other db tables on the same server by a trigger. This update is done from a join linking this table to a change table.

For example

Update patientmaster
set location = location from changetable where patientmaster.id =changetable.id

This is usually about 3-500 rows

The problem I am having is that the patientmaster table loctation is changing but not the tables that the trigger should have updated.

If I change the update statement to include an id it will work, which will mean going to a cursor for the update. is this correct behavior or a bug/issue? One of the tables being updated is very wide (almost 8000 bytes)



SQLUSA
New Member
New Member

--
23 Dec 2007 12:26 PM
Can you post your trigger?

Is it active?


Acceptable Use Policy
---