gfoulks (3/13/2014)

---

I created this trigger

CREATE TRIGGER TR_SomeTableInsteadOfFilter ON SomeTable

INSTEAD OF INSERT

AS

BEGIN

SET NOCOUNT ON;

INSERT INTO SomeTable([DateTime],Acct_Number,SSN,Script_Code,Div_indicator,first_name,last_name,ani,terminate_area,transfer_area)

SELECT [DateTime],Acct_Number,SSN,Script_Code,Div_indicator,first_name,last_name,ani,terminate_area,transfer_area

FROM INSERTED WHERE ani <> '614xxxxxxx' or ani <> '614yyyyyyy';

END

I am still able to insert records with the ani = '614xxxxxxx' or ani = '614yyyyyyy;