Is there a better way to get the current date without a time than this?
dateadd(ms, datepart(ms, getdate())*-1, dateadd(ss, datepart(ss, getdate())*-1, dateadd(mi, datepart(mi, getdate())*-1, dateadd(hh,datepart(hh, getdate())*-1, getdate())))) - 1
Thanx,
Bill Elvin