Dharmesh Sharma

Dharmesh Sharma

  • NA
  • 905
  • 917.7k

how to get data between date and name

Nov 3 2009 7:18 AM
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

Answers (3)