• Could it possible to use @table variable or CTE for processing 10 million records up? i'm afraid it will drain the memory.