SQL Query - Database name 'TempDB' ignored, referencing object in tempdb - Error

Hi EE,

I have the following query:

CREATE TABLE TempDB.dbo.#temp_CareID (CareID varchar(14));
INSERT INTO TempDB.dbo.#temp_CareID (CareID) 
(SELECT

       LEFT(rr.NUMVAL,14) BluecareID

       FROM CL_REFNOS rr

       INNER JOIN CLIENTS cc ON cc.CLIENT_ID=rr.CLIENT_ID

       WHERE NUMBER_ID='B0000000016' AND ISNULL(rr.NUMVAL,'')<>''

       GROUP BY LEFT(rr.NUMVAL,14)

       HAVING COUNT(1)>1)
;
-- SELECT CareID from TempDB.dbo.#temp_CareID;

SELECT DISTINCT

       LEFT(r.NUMVAL,14) BluecareID,

       c.LASTNAME FamilyName,

       RTRIM(LTRIM((ISNULL(c.FIRSTNAME,'') + ' ' + ISNULL(c.MIDDLENAME,'')))) GivenNames,

       c.BIRTHDATE DateOfBrith,

       CASE ISNULL(c.GENDER,'') WHEN '' THEN 'Unknown' ELSE c.GENDER END Gender,

       (ISNULL(c.CURR_ADDR1,'') + ', ' + ISNULL(c.CURR_ADDR2,'')) Street,

       c.CURR_CITY SuburbAndCity,

       c.CURR_POST Postcode

FROM CL_REFNOS r

INNER JOIN CLIENTS c ON c.CLIENT_ID=r.CLIENT_ID AND ATTENDANCE<>'T'

INNER JOIN CLTDEPT cd ON cd.CLTVISITOR_ID=c.CLIENT_ID AND cd.STATUS IN ('A','W','I')

INNER JOIN ORDERS o ON o.CLIENT_ID=c.CLIENT_ID AND o.ENDDATE IS NULL

INNER JOIN SCHGROUPCLTS sg ON sg.CLIENT_ID=c.CLIENT_ID AND sg.DEPT_ID=cd.DEPT_ID

INNER JOIN SCHGROUPCLTSTATES sgs ON sgs.CLIENT_ID=c.CLIENT_ID AND sgs.STATUS IN ('A','W','X')  AND sgs.DEPT_ID=cd.DEPT_ID

WHERE r.NUMBER_ID='B0000000016' AND ISNULL(r.NUMVAL,'')<>''

AND r.NUMVAL not IN ( SELECT CareID from TempDB.dbo.#temp_CareID )
Order by BluecareID
drop table TempDB.dbo.#temp_CareID;
GO

Select allOpen in new window

When I run it though I getting the following errors:

Database name 'TempDB' ignored, referencing object in tempdb.


What is causing this error and how to resolve it.

Any assistance is appreciated.

Thank you.