Try this:
CREATE TRIIGER trig_DoSomething ON [Test] AFTER DELETE
AS
BEGIN
insert into table1 (column1,column2,column3)
select column1,column2,column3 from Inserted where Status!='normal';
END
Avoid using
CURSOR
,you are trying to kill your System Performance .