Hi dilipd006,

I have debugged your code and the problem lies with the declaration of your parameters.

You must explicitly convert them to date e.g.

DECLARE @fromdate DATETIME = CONVERT(DATE,'2012-05-24');

DECLARE @todate DATETIME =...