I was wondering if anyone could help me past a problem that I am having using dynamic dates and stored procedures. I am new to this and have the following procedure written, This particular query will only return data if the variables @sDateFrom and @sDateTo are surrounded by single quotes however, in the stored procedure the single quotes cause the query to fail giving the error "Syntax error converting datetime from character string"

Any insights would be greatly appreciated.

Thanks,
Brent

ALTER PROC prBuildSelector (
@sNRW varchar(50),
@sDateFrom datetime,
@sDateTo datetime
)
AS

SELECT name,start_date,end_date, sku FROM product
INNER JOIN section ON product.pfid = section.pfid
WHERE product.name LIKE '%@sNRW%' AND
start_date > @sDateFrom
AND start_date < @sDateTo
ORDER BY vcfeb10_product.name
Return

Which database are you using ?

EXEC('SELECT name,start_date,end_date, sku FROM product
INNER JOIN section ON product.pfid = section.pfid
WHERE product.name LIKE ''%' + @sNRW + '%'' AND
start_date > @sDateFrom
AND start_date < @sDateTo
ORDER BY vcfeb10_product.name')