[MSSQL 2005] Speed Problem mit Update Trigger

[NormanNG]

hi,

Zitat:

EDIT

Delete
from inserted
where AMOUNT is null

sorry,
du musst die original-tabelle und "inserted" über den (primary) key joinen

SQL-Code:

Delete cc
from dbo.t_xl_costcenter_cost cc
join inserted i on i.<PK> = cc.<PK>
where KST is NULL