Here is the Question:

I'm fine with declaring the table in the beginning.

I want to check the temp table while selecting - first time through temp table will be empty.

So I want to use the record on the select - But then Insert SSN into Temp Table.

Next Record, I want to check temp table for SSN, if in temp table don't select.

If not in temp table - store in temp table and use record.

Looping