DECLARE @TaskID INT = 0; -- Replace with your TaskID value
DECLARE @TemplatePackID INT = 0; -- Replace with your TemplatePackID value

-- Check if TaskID exists in Tasks table
IF EXISTS (SELECT 1 FROM [Sysero].[dbo].[Tasks] WHERE ID = @TaskID)
BEGIN
    -- Update existing records
    UPDATE tt
    SET Completed = 1,
        CompletionDate = GETUTCDATE()
    FROM [Sysero].[dbo].[Transaction_Tasks] tt
    INNER JOIN [Sysero].[dbo].[Transactions] t ON tt.TransactionID = t.ID
    WHERE tt.TaskID = @TaskID
      AND t.TemplatePackID = @TemplatePackID;

    -- Insert missing records
    INSERT INTO [Sysero].[dbo].[Transaction_Tasks] 
        (TransactionID, TaskID, Completed, CompletionDate)
    SELECT t.ID, @TaskID, 1, GETUTCDATE()
    FROM [Sysero].[dbo].[Transactions] t
    WHERE t.TemplatePackID = @TemplatePackID
      AND NOT EXISTS (
        SELECT 1 
        FROM [Sysero].[dbo].[Transaction_Tasks] tt
        WHERE tt.TransactionID = t.ID 
          AND tt.TaskID = @TaskID
      );
    
END