SELECT ID,Name,Address,phoneno,natureofcomplaint,Assigneng,engid,assignby,assignby_id,status,remark,assigndate,resolvedate,@fromdate,@todate FROM call_request_master WHERE CONVERT(VARCHAR(10),assigndate,101) BETWEEN @fromdate AND @todate AND Assigneng=@enggname