BoRdo -

About

	Oct. 29th, 2008 @ 11:59 am

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

(Tell`me)

Top of Page