Update trigger with a join

Last Post 23 Dec 2007 11:26 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
timcronin
New Member
New Member

--
05 Dec 2007 07: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 11:26 AM
Can you post your trigger?

Is it active?
You are not authorized to post a reply.

Acceptable Use Policy