on your parameters, you're using Cstr() - try Cdate() function instead, since your proc is looking for DateTime parameters

what is the exact error message?

KC

The first thing to check for is to make sure that in your stored procedure you place at the top (after your parameters) SET NOCOUNT ON. That may be the...

Try this:

create procedure dbo.myproc

as

select distinct o.odid, r.rcid, r.rqty, r.date, netQty

from receive r inner join order12 o on o.odid = r.odid

where o.partid = (selectpartid from part where [desc]= '+y+') and r.netQty...