I get the following error. Any ideas what it could be?
Msg 206, Level 16, State 2, Line 1
Operand type clash: date is incompatible with tinyint
select * from tblOrgHours where Agencyid = 74 and Fiscal = 2015 And ActivityDate >= '07/01/2014' And ActivityDate <= '06/30/2015' having min(activitydate) = 7
Basically, within this data range, I want all records that begin in the month specified. In this case, its July