Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-28 : 23:53:45
|
Mala writes "Hi,
The trigger fires and performs activities for all the record but for my current inserted record. I want even that to be included. Please let me know what is wrong with the following trigger.
create trigger Trg_UpdHrd
on t_inv_header1
for insert
as
if exists ( select a.inv_no,b.i_partno,b.inv_bu,b.inv_wh_from,b.inv_stkcatg,b.i_upartno,b.inv_tqty,a.inv_off,b.inv_batch,c.i_cyc_abcd
from t_inv_header1 a, t_inv_details1 b, m_materials c
where a.inv_no=b.inv_no and a.inv_batchpost=0 and c.i_partno=b.i_partno
and a.inv_type='pi')
begin
exec bosusersp.sp_stkupdate 'pi'
end
Thanks in advance.
Bye,
Mala" |
|
|
|
|
|
Triggers