• I also use SCOPE_IDENTITY();

    Why would you need to waste memory using temp mem tables.