I have table for which I want to check the count for particular user for dates between 01/04/2016 - 17/05/2016
I have added the query like below
select count(CUser_Id) from inward_doc_tracking_trl
where CSTATUS_flag = 4
and NStatus_Flag = 1
and CUser_Id = 1260
now how to add the date part and check ??
I am using SQL server 2005
Aucun commentaire:
Enregistrer un commentaire