I am using sql-server 2005.
I am writing a trigger for table A.
When table A is updated, i wish to record in table Y data from rows in table B which reference the primary key for table A. (i.e.: there is a column in table b which has a foreign key which references table A. I need data from all the rows which have this foreign key in it)
Is this possible (and how would I do it)?
Can I write a loop within the trigger which runs for each row of a select query?