UPDATE testcourselog SET grade='a' WHERE statusid=4

USE [online]
GO
/****** Object:  Trigger [dbo].[gl_courselog_iscounted_update]    Script Date: 12/10/2007 16:49:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER TRIGGER [dbo].[gl_courselog_iscounted_update]
   ON  [dbo].[testcourselog]
   AFTER INSERT,UPDATE
AS 
IF UPDATE(grade) AND (SELECT count(*) FROM inserted) > 0
BEGIN
 
IF @@ROWCOUNT = 1 
BEGIN
 
	SET NOCOUNT ON;
	UPDATE testcourselog SET iscounted=1 WHERE userid=(SELECT userid FROM inserted)
 
END
ELSE 
BEGIN
 
	UPDATE testcourselog SET iscounted=1 
	          FROM testcourselog t JOIN deleted d 
		      ON t.userid = d.userid 
		     --WHERE d.statusid=4 --I think this shouldn't be required
 
 
END
END

8	NULL      	False
8	NULL      	False
7	NULL      	False
8	NULL      	False
8	NULL      	True
4	a           	True
4	a           	True
2	NULL	True
2      	NULL      	True
2      	NULL      	False
8      	NULL      	False
6      	NULL      	True
8      	NULL      	False
6      	NULL      	False
8      	NULL      	True
4      	a           	True
8      	NULL      	True