DECLARE @BadgeDefinitionID BIGINT = 420
DECLARE @UserIDs NVARCHAR(MAX) = '11279,11133,11227,11100,1,2,3,4'
BEGIN
     DECLARE @Users TABLE
     (
        Id BIGINT
     )
     INSERT INTO @Users
     SELECT Item FROM dbo.fn_SplitToBigint(@UserIDs, ',')
     select * from @Users

     --INSERT INTO IRBadgeUserAssignet(IRBadgeDefinitionID, IRUserID)
     SELECT @BadgeDefinitionID, u.Id--,bua.IRUserID
     FROM IRBadgeUserAssignet as bua
          RIGHT JOIN @Users as u ON bua.IRUserID = u.Id
     WHERE bua.IRUserID IS NULL

end