|FiscalYear|Amount|
|2012      |250.25|
|2013      |175.13|

Merge into [dbo.HRIS_RecruitingGL] as trg
using [Staging] src
       on src.FiscalYear = trg.FiscalYear

when matched and trg.fiscalYear != src.FiscalYear
then update set trg.FiscalYear = src.FiscalYear

when not matched by target
then   insert (FiscalYear, Amount)
       values (src.fiscalYear, src.Amount)
;

MERGE	dbo.HRIS_RecruitingGL AS tgt
USING	(
		SELECT	DATENAME(YEAR, GETDATE()) AS FiscleYear,
		FROM Staging.HRIS_RecruitingGL
		) AS rgl ON rgl.FiscalYear = tgt.FiscalYear
WHEN	MATCHED
		THEN	UPDATE
			SET	tgt.FiscalYear = rgl.FiscalYear,
				tgt.Amount = rgl.Amount
WHEN	NOT MATCHED BY TARGET
		THEN	INSERT	(
					FiscalYear,
					Amount
				)
			VALUES	(
					rgl.FiscalYear,
					rgl,Amount
				);

MERGE	dbo.HRIS_TORateFY AS tgt
USING	(
		SELECT	DATENAME(YEAR, GETDATE()) AS [Year],
			SUM(CASE WHEN EmpStatusName = 'Active' THEN 1 ELSE 0 END) AS HistoricalHC,
			SUM(CASE WHEN EmpStatusName = 'Withdrawn' AND TermYear = DATENAME(YEAR, GETDATE()) THEN 1 ELSE 0 END) AS NumbOfTermEE
		FROM	dbo.HRIS_EEMaster
		WHERE	ChangeStatus = 'Current'
			AND EmpStatusName IN ('Active', 'Withdrawn')
	) AS src ON src.[Year] = tgt.[Year]
WHEN	MATCHED
		THEN	UPDATE
			SET	tgt.HistoricalHC = src.HistoricalHC,
				tgt.NumbTermedEmp = src.NumbOfTermEE
WHEN	NOT MATCHED BY TARGET
		THEN	INSERT	(
					[Year],
					HistoricalHC,
					NumbTermedEmp
				)
			VALUES	(
					src.[Year],
					src.HistoricalHC,
					src.NumbOfTermEE
				);

MERGE   dbo.HRIS_RecruitingGL AS tgt 
USING   (
        SELECT  FiscalYear,
                Amount
        FROM    Staging.HRIS_RecruitingGL
        )       AS rgl 
        ON      rgl.FiscalYear = tgt.FiscalYear
WHEN    MATCHED
THEN    UPDATE
        SET     tgt.FiscalYear = rgl.FiscalYear,
                tgt.Amount = rgl.Amount
WHEN    NOT MATCHED BY TARGET
THEN    INSERT  (
                FiscalYear,
                Amount
                )
        VALUES  (
                rgl.FiscalYear,
                rgl,Amount
                );

    Msg 207, Level 16, State 1, Line 3
    Invalid column name 'FiscleYear'.
    Msg 207, Level 16, State 1, Line 7
    Invalid column name 'FiscalYear'.

Msg 110, Level 15, State 1, Line 1
There are fewer columns in the INSERT statement than values specified in the VALUES
clause. The number of values in the VALUES clause must match the number of columns
specified in the INSERT statement.

        VALUES  (
                rgl.FiscalYear,
                rgl,Amount
                );

[Execute SQL Task] Error: Executing the query "MERGE   dbo.HRIS_RecruitingGL AS tgt 
USING   (
..." failed with the following error: "The MERGE statement attempted to UPDATE or DELETE
the same row more than once. This happens when a target row matches more than one source
row. A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple
times. Refine the ON clause to ensure a target row matches at most one source row, or use
the GROUP BY clause to group the source rows.". Possible failure reasons: Problems with
the query, "ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.