I have a table named tblAttendance in SQL 2008 that has a listing of all students and their hours. I would like to find all new records that have started to become active. This is figured out by finding the first month a person has a total > 0
Using the following fiscal month pattern order starting with June, I would like to find records where the first month the total > o.
Please see my attachment and notice that Tajour Brown is in 3 months, but he is only counted for the first time in September. According to the list above, since September is the first month he actually had hours, and that will be the only month we need to count him. At the end of the year the total should equal the total number of distinct individuals who actually had hours
Let me know if I have to clarify and thank you for your help. It is greatly appreciated.