DECLARE @Now DATETIME = GETDATE(); DECLARE @Today DATE = @Now; DECLARE @Yesterday DATE = DATEADD(DAY, -1,@Today); DECLARE @NowLookup int = CAST(CONVERT(varchar,@Now,112) as INT);