Dynamic SQL && Parameter Inside A SP Not Working

When I run the query below on my DB, it gives the following error:

Server: Msg 8114, Level 16, State 5, Procedure partstlist ...
Error converting data type varchar to float.

Only after I replace the      " + @d + " section with a float numnber such as 39020.5 does it work fine
It's reported that my temporary table named #tbl doesn't exist within the scope of the environment that the EXEC(UTE) command operates.
Someone said that I couldn't combine dynamic SQL and temporary tables or table variables...
and that I would have to use a global temp table "##tbl" or a permanent table.

So here I have appearantly a "DYNAMiC SQL & TEMPORARY TABLE" problem. That's sure.

But I don't have much knowledge and experience with SQL tables and have difficulty forming a global temp table "##tbl" or a permanent table.
and I have to employ the datetime variable dynamically @d inside the Dynamic SQL string.

So what kind of a code should I use here to properly combine Dynamic SQL string with my dynamic datetime variable?
I'd be grateful if you could post your code suggestions so that I can try them on my DB ..

alter PROCEDURE partslist
@no INT,
@dt DATETiME
AS
DECLARE @s VARCHAR(5000)
DECLARE @d float
SET @d = CONVERT (float, @dt2)
create TABLE #tbl
(pageindex int IDENTITY(1,1) PRIMARY KEY , prt_name varchar(50),
prt_country varchar(50) , prt_date smalldatetime, partID int , prt_cat varchar(50),
prt_product_type nvarchar(10), producer_company nvarchar(50), producer_city nvarchar(50),
prt_released DATETIME, dvalue float, datevalue varchar(26) )
BEGiN
SET ANSI_WARNINGS OFF
SET ROWCOUNT @no
SELECT @s = 'INSERT INTO #tbl SELECT prt_name, Countries.Val AS ''prt_country'' ,
prt_date, partID ,
partsCategories.Val AS ''prt_cat'' ,
partsProductTypes.Val AS ''prt_product_type'' , producers.producer_company AS ''producer_company'' ,
producers.producer_city AS ''producer_city'' ,  prt_released , CONVERT (float, prt_released) ,
CONVERT (varchar(26) , prt_released, 109) FROM producer_parts 
JOIN partsProductTypes ON (producer_parts.prt_product_type = partsProductTypes.ID)
JOIN partsCategories ON (producer_parts.prt_cat = partsCategories.ID)
JOIN Countries ON (producer_parts.prt_country = Countries.ID)
JOIN producers ON (producer_parts.producerID = producers.producerID) WHERE prt_visible = 1 
AND CONVERT (float, prt_released) > ' + @d + ' AND CONVERT (float, prt_released) < 39025.5
ORDER BY prt_released DESC SELECT * FROM  #tbl'
EXEC (@s)
SET ROWCOUNT 0
END
GO partslist 10 , '10.10.2006 10:10:10' -- This is just to test the SP.

This code may not be syntatically correct, it's a re-edited version of my code which works fine in my DB.