TSQL: Counting the number of visits base on year of visit
Posted on 2010-08-14
I need some help with the count feature. I want to know if it is possible to use the count function to determine how many times a person has came in for a year up to a particular date. For example if a person has came in 10 times starting from dec 2009 ( 3 times) to feb 2010 ( 7 times). So if i put in a jan date, it will count all the visits up to that date, but the entire of 2010.
I hope that makes sense
thanks in advance!!