;MERGE INTO dbo.[TargetTable] AS [Target]
    USING (SELECT ID AS TargetTableID FROM dbo.[BookTable]) AS [Source]
    ON [Target].TargetTableID = [Source].TargetTableID

    WHEN MATCHED AND [Target].isDelete = 1
    THEN DELETE
            
    WHEN MATCHED AND NULLIF([Source].Title,'') IS NOT NULL
    THEN UPDATE
        SET
             [Target].Title = [Source].Title
            ,[Target].Text = [Source].Text

    WHEN NOT MATCHED BY TARGET AND NULLIF([Source].Title,'') IS NOT NULL
    THEN INSERT 
           (
            Title
           ,Text
           )
        VALUES
           (
            [Source].Title
           ,[Source].Text
           )

    WHEN NOT MATCHED BY SOURCE AND YEAR([Target].DatePublished) < 2013
    THEN DELETE;