>How do you create a memory table (vs temp table)? I simply have not done it before
>
>>Why using a temp table instead of a memory table?

create @variable table (..) -- memory table

create table #temp (...) -- temporary table created in the tempDB database.

Both can be used in your procedure with not much difference.