CREATE TRIGGER CHECK_RANGE ON ASSET_CLASS

FOR INSERT, UPDATE

AS

IF NOT EXISTS(SELECT * FROM inserted i JOIN RANGE r ON i.NO_RANGE = r.NO_RANGE WHERE r.ACCNT_TYP = 'A')

BEGIN

RAISERROR('Invalid NO_RANGE', 16, -1);

ROLLBACK;

END;

GO

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]