set @ttQueryFrom = '02/04/2002 00:00:00' set @ttQueryTo = '02/05/2002 00:00:00' select begintime,endtime from meetings where deptID = @tiDeptID and begintime >= @ttQueryFrom And begintime < @ttQueryTo>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