select distinct *

from

tableA

where

-- Greater than or equal to yesterday at 00:00:00.000 (midnight)

h.created >= dateadd(dd,datediff(dd,0,getdate())-1,0)

-- Less than today at 02:00:00.000 (2am)

h.created < dateadd(dd,datediff(dd,0,getdate()),'02:00')