the system is not designed to do that so i have to go this route.. I didnt not write the source code

I can however i need to do this in order to log actions when the stage in O_Stage changes.. As the actions are not noted when the stage in the...

i Basically need to check to see if a value already exists and if it does, then delete old value and insert new value

Here is my trigger: With actual table names (above was only an example of logic)

alter TRIGGER [dbo].[TRIGGER_STAGE_INSERT]
ON [dbo].[AMGR_Opportunity_Tbl]
...

Thank you for this. One last question - wouldnt it be easier to do this via a SP or Trigger?

I figured it out thanks - with a union all clause

Thanks Sue. it works perfectly.
If i now want to calculate the closing balance, that will be the opening balance + all in progress deals done in current month.. Can...

its a custom table that i created:

CREATE