USE [LAB_DB];
GO

SET NOCOUNT ON;
BEGIN TRANSACTION;

MERGE INTO dbo.tbl_lab_setup_Test AS Target
USING (VALUES
    ('4019', 'HM', 18, N'Hypersegmented Neutrophil', N'Hypersegme', '4019', NULL, '08', '01', '000', '000', 0.00, 0, 0, 'admin'),
    ('3076', 'HM', 2,  N'Hematocrit',               N'Hematocrit', 'HM0004', NULL, '08', '01', '000', '000', 80.00, 0, 0, 'admin'),
    ('3041', 'UA', 1,  N'Color (UA)',                N'Color (UA)', 'MC001',  NULL, '09', '02', '000', '000', 150.00, 0, 0, 'admin')
    -- ข้อมูลรายการอื่น ๆ ...
) AS Source (
    Test_Code, Test_Group_Code, Test_Seq, Test_Name, Test_Display_Name,
    Test_His_Code, Test_Checkup_Code, Specimen_Type_Code, Test_Data_Type_Code,
    Unit_Code, Formula_Code, Test_Cost, Test_Send_Out_Flag, Test_Inactive, Test_Trx_By
)
ON (Target.Test_Code = Source.Test_Code)
WHEN MATCHED THEN
    UPDATE SET
        Target.Test_Group_Code    = Source.Test_Group_Code,
        Target.Test_Seq           = Source.Test_Seq,
        Target.Test_Name          = Source.Test_Name,
        Target.Test_Display_Name  = Source.Test_Display_Name,
        Target.Test_His_Code      = Source.Test_His_Code,
        Target.Specimen_Type_Code = Source.Specimen_Type_Code,
        Target.Test_Data_Type_Code= Source.Test_Data_Type_Code,
        Target.Test_Cost          = Source.Test_Cost,
        Target.Test_Send_Out_Flag = Source.Test_Send_Out_Flag,
        Target.Test_Inactive      = Source.Test_Inactive
WHEN NOT MATCHED THEN
    INSERT (
        Test_Code, Test_Group_Code, Test_Seq, Test_Name, Test_Display_Name,
        Test_His_Code, Test_Checkup_Code, Specimen_Type_Code, Test_Data_Type_Code,
        Unit_Code, Formula_Code, Test_Cost, Test_Send_Out_Flag, Test_Inactive, Test_Trx_By
    )
    VALUES (
        Source.Test_Code, Source.Test_Group_Code, Source.Test_Seq, Source.Test_Name, Source.Test_Display_Name,
        Source.Test_His_Code, Source.Test_Checkup_Code, Source.Specimen_Type_Code, Source.Test_Data_Type_Code,
        Source.Unit_Code, Source.Formula_Code, Source.Test_Cost, Source.Test_Send_Out_Flag, Source.Test_Inactive, Source.Test_Trx_By
    );

COMMIT TRANSACTION;
GO