Re: [SQL] query to return hourly snapshot

2006-04-04 Thread Richard Broersma Jr
Yes! Thanks you very much! --- Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Tue, Apr 04, 2006 at 05:58:26PM -0700, Richard Broersma Jr wrote: > > I am look for help in developing a query that will return the nearest > > process record that was logged at or after each hour in a day (i.e. > > hour

Re: [SQL] query to return hourly snapshot

2006-04-04 Thread Michael Fuhr
On Tue, Apr 04, 2006 at 05:58:26PM -0700, Richard Broersma Jr wrote: > I am look for help in developing a query that will return the nearest > process record that was logged at or after each hour in a day (i.e. > hourly snapshot). Are you looking for something like this? SELECT p.process, date_tr

[SQL] query to return hourly snapshot

2006-04-04 Thread Richard Broersma Jr
I orginally sent this email to the [novice] list but did not get any response. I am look for help in developing a query that will return the nearest process record that was logged at or after each hour in a day (i.e. hourly snapshot). Below are typical sample data. Also, I've included a