mardi 17 mai 2016

Check count of user in a table for particular date

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