@temp table in stored procedure in sql server 2008 r2

See more:

C#

SQL-Server-2008R2

Hi guys,

i have created one stored procedure, where i have declare one @temptable table n inserting n fetching rows from it.

My question is,

i have created this @temptable in which i'm inserting data n fetching it.
does it take the memory,
do i have to delete the rows n table..

stored procedure:

DECLARE @MaxDate DATE

SELECT @MaxDate = MAX(JobDate) from tbl_etsjob where JobDate <= @ReportDate

print @MaxDate

insert into @TempTable
select 
	  JobID,
	  UnitID ,
      DepartmentID ,
      JobDate ,
      UnitStatus ,
      Rig ,
      Well ,
      JobProcess ,
      NPSJob ,
      CrewStatus ,
      Operator ,
      js.JobStatus
from tbl_etsjob j
INNER JOIN tbl_JobStatus js on js.Ets_JobID = j.JobID
where JobDate = @MaxDate

i have to delete statement are fetching or not.?? to free the memory

plz let me know


Thanks