Just want to take note of this one it always slips my mind; SELECT FROM a Table WHERE a DateTime Column between [Current DateTime] and [Current Date Midnight]
This should work:
SELECT [Column List]FROM [TableName]WHERE [DateTime Column] BETWEEN getDate() AND CAST( DATEADD(ms, 86399990, (CAST(FLOOR(CAST (getdate() AS DECIMAL(12, 5))) AS DATETIME))) AS DATETIME)
Quick Select:
SELECT getDate() AS [Current Date], DATEADD(ms, 86399990, (CAST(FLOOR(CAST(getDate() AS DECIMAL(12, 5))) AS DATETIME))) [Before Midnight]