Thanks Bruce and Noel.

Testing for nulls fixed my issue.

Hi Bruce,

I changed the code to

USE [Performance]

GO

/****** Object: Trigger [dbo].[trgInsHSBCNetEPM1] Script Date: 02/19/2009 10:58:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[trgInsHSBCNetEPM1]

ON [dbo].[FundPerfValues]

AFTER INSERT, Update

AS

If...

Yes, but the variables change because the same row is not always updated and put in the INSERTED Table.

Adding Begin and End doesn't change the results. I get the...

Hi Noel,

My user enters one value, TotalNAVFinal, for a given month and I create a new row for the following month. This is why it's coded for one row....