Thats it!!

Thank you Thank you Thank you

Jeremy and Matt Miller, you guys are fantastic, saved the day.

Thank you for replies and your time but these are giving me Cumulative totals, i want to get the total per each hour as the time stamps change.

-Thank you

Yes, change the time stamps like you said.

So varday is '01/01/2008 11:00:00' to a specified end date. with time stamps changing for each hour/expanding this to a month worth of...

the following query gives me user count as of 11AM, if transaction hasn't ended as of 11AM (and they are logged in system from whatever time say 9AM in the...

Jamie and Sergiey

Thank u for quick reply, i am going to try these solutions and report back.

thanks everyone for replies. update column worked perfectly.

Thank you peter.

but how i can pass the address value? from address column in table.

have more than 300 rows.

Sorry was not clear in my original posting.

Looking for a way to delete records in a table older than 30 days. Table does have a column with time stamps of...