dest

as
(
SELECT
       [Дата]
      ,field1
      ,field2
FROM govno
where [Дата] >= @Data1
      and
      [Дата] < @Data2

)


    merge dest as d

    using

    src

    on
            (
            d.[Дата]=src.[Дата]

            )

    when matched
    and
            (
            d.field1!=src.field1
            or
            d.field2!=src.field2
            )

    then update set


            d.field1=src.field1,
            d.field2=src.field2



    when not Matched by target
    then insert


        (
            [Дата],
            field1
            field2
        )

        values
        (

            src.Дата,
            src.field1=src.field1,
            src.field2=src.field2
        )

when not matched by source
then delete

OUTPUT deleted.*, $action, inserted.*;