I am having something wierd...probably me, but if I use the between clause in the where portion, I get zero results. I am trying this in the QA. If I do begintime >= @ttQueryFrom I get results, but if I do begintime between @ttQueryFrom and @ttQuery to it returns nothing and if I do begintime >= @ttQueryFrom and begintime <= @ttQueryTo I get no results.
declare @tiDeptID int
declare @ttQueryFrom datetime
declare @ttQueryTo datetime
set @ttQueryFrom = '02/04/2002 00:00:00'
set @ttQueryTo = '02/04/2002 23:59:00'
set @tiDeptID = 23
select begintime,endtime
from meetings
where deptID = @tiDeptID
and begintime between @ttQueryFrom and @ttQueryTo