SELECT categoryid
INTO   #cateids
FROM   tg_categories
WHERE  categoryname = 'BlackJack'
       AND mastercategory IN (SELECT categoryid
                              FROM   tg_categories_operators
                              WHERE  operatorid IN ( 101, 100 )
                                     AND clientid = 2)

-- create a cursor to insert the games for operators cats
DECLARE @AssignGamesCursor AS CURSOR
DECLARE @CatID INT

SET @AssignGamesCursor = CURSOR
FOR SELECT *
    FROM   #cateids

---------------------
OPEN @AssignGamesCursor

FETCH next FROM @AssignGamesCursor --Start the cursor
INTO @CatID

WHILE @@FETCH_STATUS = 0 --while there is a loaded record, keep processing
  BEGIN
      INSERT INTO tg_categories_games
      SELECT @CatID GameId,
             partyid,
             gameorder
      FROM   tg_categories_games
      WHERE  categoryid IN (SELECT categoryid
                            FROM   tg_categories
                            WHERE  categoryname = 'BlackJack'
                                   AND mastercategory IN (SELECT categoryid
                                                          FROM
                                       tg_categories_operators
                                                          WHERE  operatorid = 3
                                                                 AND
                                                         clientid = 2)
                           )
  END

CLOSE @AssignGamesCursor