SELECT
    COUNT(*)
FROM
    myTable
WHERE
    AccountID NOT IN (SELECT
                          RIGHT('000000000' + CAST(Col1 AS VARCHAR(9)), 9)
                      FROM
                          #A) -- Returns records in myTable that no longer exist