INSERT INTO @PROCMASKSTABLE SELECT CAST(c.value AS INT) & Bits.BitMask AS Mask FROM sys.configurations AS c CROSS JOIN (SELECT Number AS BitNo, CAST(POWER(2.0, Number) AS BIGINT) AS BitMask FROM Tally WHERE (Number <= @NUMPROCS and Number <= 31)) AS Bits WHERE (c.name = 'affinity mask')
select 1073741824 * 2 -- 1073741824 == 2^30