I have a sample of data from my table in sql. The table is named AttendanceGrid.
Unfortunately there was some poor planning and now I have to figure out how to get distinct values from two fiscal years. The problem is that the ID's are different in Fiscal 2013 and Fiscal 2014. however the rest of the record is considered a duplicate.
How is it possible to get a count by committee of all the unduplicated records from September 2013 to August 2014
Here is what I started and am getting the wrong results....
Select Committee, count(*) from AttendanceGrid Where (Month IN ( 'September', 'October', 'November','December','January', 'February','March','April', 'May','June') And Fiscal = 2013)
(Month IN ( 'July', 'August') And Fiscal = 2014)
And Total > 0
AND [CSW/TitleXX] = 'T'
Group by Committee, [First Name],[Last Name],BirthDate
Order by Committee