Here is another variation on the math method that my testing says is a little faster:

DECLARE @Billion INT;

SET @Billion = 1000000000;

SET STATISTICS TIME ON;

SELECT @Bitbucket = RIGHT(@Billion+(C1*1000)+C2,9)

FROM #TestTable;

SET STATISTICS TIME OFF;