INSERT INTO Burcon.FACT_Player_match
    SELECT  matches.Id, players.player_id, matches.tourney_id,
        CASE
                WHEN matches.set_3 IS NULL OR matches.set_3 = ''
                   THEN 2
                   ELSE 3
           END AS INT
    , 1
    FROM dbo.matches matches JOIN dbo.players players ON matches.winner_id = players.player_id;

INSERT INTO Burcon.FACT_Player_match
    SELECT  matches.Id, players.player_id, matches.tourney_id,
        CASE
                WHEN matches.set_3 IS NULL OR matches.set_3 = ''
                   THEN 0
                   ELSE 1
           END AS INT
    , 0
    FROM dbo.matches matches JOIN dbo.players players ON matches.loser_id = players.player_id;