how to get data between date and name

Dharmesh Sharma

17y4.9kSQL

hi

i m using the sql query but i got a problem
mu query is

 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

now i got a error in my C# code

the query understan as the date between date and Assigneng
so queri wron

i can not give the understand to query

i got data from database two date
and this data again filter by name

give me some idea
in sql procedure
help me

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilanka Dharmadasa17y ago
Accepted answer
Hi Sharma,

As I understand, you want to filter data based on the two queries. Your query has a small mistake.
Change your query as follows.

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

For @fromdate and @todate you should pass correct dates. You get this error when your dates are not valid.

If you can paste your c# code here.
Dharmesh Sharma17y ago
i alow the changes in query but get same error in C# code
Error is
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999