SELECT COUNT(Job) AS Jobs FROM dbo.Job WHERE (Received BETWEEN DATEADD(d,DATEDIFF(d,GETDATE()),0) AND DATEADD(d,1))
WHERE DateDiff(d,Received,GETDATE()) = 0
编辑：正如本答案的评论中所述,这不是一个理想的解决方案.检查这个帖子中的其他答案.
