The user interface restricts multiple cost changes. So this trigger works fine .

GO

/****** Object: Trigger [dbo].[OnUpdateVersionCost] Script Date: 12/18/2009 13:51:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER...

Thank You for help everybody.

Hope this helps .

Tables:

1. Cost Table (All costs defined here )

2. Version(All versions defined here)

3. VersionCost(cost detail for a version)

4. VersionCostHistory (Tracks whatever is added/deleted and...