Viewing post 1 (of 1 total)
i think this is what you require
needs to be in a before delete trigger
update summary
set countusedtogether=countusedtogether-n
from summary as s
inner join (
select a.iditem as i1
,b.iditem as i2
,count(*)...
April 25, 2010 at 5:57 am
#1157380