How to reuse dataset in that stored procedure
This is what i would do without knowing the table structure. 

Otherwise I might create the temporary table with the correct columns first, and insert in it afterwards (and not use select * to insert but instead select the needed columns from the emp table). 

I used a temporary table instead of a table variable as to (in most cases) improve query performance.

 SELECT *
 INTO  #FullTimeEmpResult
 FROM emp WHERE TYPE='FullTime';


 SELECT * FROM #FullTimeEmpResult WHERE salary &gt;5000;

 SELECT * FROM #FullTimeEmpResult WHERE YearOfExperience&gt; 5;

 DROP TABLE #FullTimeEmpResult;