/* Create close cut off date time variable.*/ DECLARE @CutOffDateTime DATETIME SET @CutOffDateTime = CONVERT(DATETIME, CONVERT(NVARCHAR(10),CONVERT(DATE,GETDATE())) + ' 10:10:00.000')