Do NOT use code like that. Remember that triggers
operate on sets, not rows. Perhaps this:

CREATE TRIGGER TableName T ON Tablename
FOR UPDATE AS
IF EXISTS
(SELECT *
FROM inserted
WHERE AIA = 'CLOSED'
AND AIB IS NULL)
BEGIN
RAISERROR('Closed on date not provided for a closed
item', 15, 1)
ROLLBACK
END

Note that if any row violates your rule, the entire
updated set will be rolled back.

--- "Khrishnamurthy, Sankar"
<sankar.[Email Address Removed] wrote:
> This did the trick!
>
> CREATE TRIGGER [TABLENAME_T] ON [TABLENAME]
> FOR UPDATE AS
> DECLARE @AIA VARCHAR(8), @AIB SMALLDATETIME
> SELECT @AIA = AIA, @AIB = AIB FROM INSERTED
> IF ( @AIA = 'CLOSED' AND @AIB IS NULL )
> BEGIN
> RAISERROR('Closed on date not provided
> for a closed item',
> 15, 1)
> ROLLBACK TRANSACTION
> END
> --
> Sankar

__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/
MS Sql Server LazyDBA home page