I just scripted a report, that for most intents and purposes works, but I
want it to run daily, not need any intervention from me on a daily basis,
and instead of grabbing the most recent 24 hours of data, just grab data
between midnight and midnight. if you could help me with the code, or
better yet, point me to a good sql (sybase) resource, I'd much appreciate
it.

thanks!


oh, this is what I have right now:

declare @end datetime,
@start datetime
select @end = getdate()
select @start = dateadd(day,-1,@end)

"Khee Mao" <big_bad_buddha_daddy (AT) yahoo (DOT) com> wrote

thanks for nothing, guys! I figured it out though.

select @end = convert(datetime, convert(char(11),getdate()))