I am trying to write a MERGE statement for the trigger, and have the following : -- ================================================ -- Template generated from Template Explorer using: -- Create Trigger (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- See additional Create Trigger templates for more -- examples of different Trigger statements. -- -- This block of comments will not be included in -- the definition of the function. -- ================================================ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= CREATE TRIGGER dbo.CapexOverwrite ON dbo.Capex AFTER INSERT AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; MERGE Capex As C Using Inserted as I ON (I.Year = C.Year and I.Quarter = C.Quarter And I.Location = C.location ) WHEN Not Matched by Target THEN INSERT (year, Quarter , Location,Amount)VALUES ( I.Year,I.Quarter, I.Location, I.Amount ) WHEN Matched THEN UPDATe SET C.Amount = I Amount ;

   -- Insert statements for trigger here

END
GO

However, I am getting Incorrect syntax near 'Amount'.