Temp Table Problem

I have developed the query below

declare @start datetime
declare @end datetime


set @start = dateadd(day,-1,convert(datetime,convert(varchar(10),getdate(),120),120))
set @end = dateadd(day, 1, @start)


DECLARE @TxtPtr binary(16), @applicantid integer, @Data varchar(8000), @Offset integer
SET              NOCOUNT ON CREATE TABLE #Temp(applicantid integer, RTF text) DECLARE YourCursor CURSOR FOR
                          SELECT     gradrec_coverletter_t.applicantid
                           FROM         gradrec_coverletter_t inner join GradRec_Applicant_T on gradrec_coverletter_t.applicantid = GradRec_Applicant_T.applicantid
where Submitted_DT >= @start and Submitted_DT < @end

OPEN YourCursor FETCH NEXT
FROM         YourCursor
INTO            @applicantid WHILE @@FETCH_STATUS = 0 BEGIN INSERT #Temp(applicantid, RTF)
VALUES     (@applicantid, '')
                          SELECT     @TxtPtr = TEXTPTR(RTF), @OffSet = 0
                           FROM         #Temp
                           WHERE     applicantid = @applicantid WHILE @OffSet IS NOT NULL BEGIN
                                                      SELECT     @Data = CAST(CAST(SUBSTRING(document_im, @Offset + 1, 8000) AS varbinary(8000)) AS varchar(8000))
                                                       FROM         gradrec_coverletter_t
                                                       WHERE     applicantid = @applicantid IF Len(@Data) > 0 BEGIN UPDATETEXT #Temp.RTF @TxtPtr @Offset NULL @Data
SET              @OffSet = @OffSet + 8000 END ELSE BEGIN
SET              @OffSet = NULL END END FETCH NEXT
FROM         YourCursor
INTO            @applicantid END CLOSE YourCursor DEALLOCATE YourCursor
                          SELECT     applicantid, RTF
                           FROM         #Temp
DROP TABLE #Temp

My problem is I keep getting the error message

There is already an object named #temp in database.

Can anybody help?
Start Free Trial