My problem is VRCRAMT is not properly updating with BILLAMOUNT.

ie VRCRAMT = 0 even if BILLAMOUNT > 0

please help

PRASAD SJ

Yes, only one record will be inserted into the table [dbo].[BILL_TRN] at a time.

PRASAD SJ

USE [FAS]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[BILL_TRN_AFTINS_TRIGGER]

ON [dbo].[BILL_TRN]

AFTER INSERT

AS

BEGIN

SET NOCOUNT ON;

IF (select i.BILL_TYPE from inserted i) = 'PURCHASE'...