Still I am not getting the result.

I tryed with Your piece code which you have send me.

SubmitDay = (SELECT 1 WHERE xxxx.dtSubmitDate BETWEEN @AsOfBeginDate AND @AsOfEndDate),

--SubmitDay = (SELECT 1 WHERE xxxx.dtSubmitDate BETWEEN 'Aug 17 2007 12:00AM' AND 'Aug 17 2007 11:59PM'),

C these two lines.

1-with the variables.

2-with...

exec usp_rptsales '8/1/2007','policy'

This is how I am calling the stored procedure.

Here the sample code.

Please help me out in this.

If I give the dates directly The stored procedure is giving the result is good.

If I give the dates with the variables...