title: do we need to drop the #temp table after select into
body: <p>I know we will have to drop the table manually after using create table, but how about select into #temp ? will it be cleaned up at the end of the the stored proc? thanks </p>