madevil Šodien saņēma šādu invaitu uz pusdienām :)
declare @time1 datetime declare @time2 datetime set @time1 = '2008-10-29 12:00:00.000' set @time2 = '2008-10-29 13:00:00.000' select Place, min(TimeStamp) from dbo.tblFoodPlacesOldriga where place in ('Tekila','HesBurger', 'StenderaOsta', 'JackD') and timeStamp between @time1 and @time2 group by Place order by 2
![[info]](http://klab.lv/img/userinfo.gif){kind=small}