where date >= dateadd(hh,8,dateadd(d,datediff(d,'1949-09-09',getdate()),'1949-09-09')
and date < dateadd(hh,9,dateadd(d,datediff(d,'1949-09-09',getdate()),'1949-09-09')
p.s. if you're wondering what 1949-09-09 is, dat's my boifday
Rudy, I'm pretty sure I've read it somewhere but I can't seem to find the link to that article that someone posted on this forums, or remember the exact reasons. My question is: why are you using >= and < instead of between? Is there any performance advantage with your approach? Is it just personal preference?
Sorry for appending this question in this thread but I'm asking this because I tend to use BETWEEN a lot