Trigger will be called as many rows gets updated , so that should work ,

USE [TRAIN]

GO

/****** Object: Trigger [dbo].[tr_CHECK_SRVSTAT] Script Date: 07/21/2009 09:47:25 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[tr_CHECK_SRVSTAT]

ON [TRAIN].[dbo].[SVC00200]

AFTER UPDATE

AS

DECLARE @CALLNBR varchar(50)

DECLARE @SRVSTAT char(3)

IF UPDATE(SRVSTAT)

BEGIN

SELECT @SRVSTAT = SRVSTAT,

@CALLNBR = CALLNBR

FROM INSERTED

IF @SRVSTAT = 800

BEGIN

--CALL SP THAT PASSES CALLNBR AND IF HAS NOT BEEN EMAILED THEN SEND EMAIL AND UPDATE

EXEC sp_webServiceRequest_EmailComplete @CALLNBR

END

END