SQL server how can I combine times such 6.30 - 7.00 and 7.00-7.30 to become 1hr gap instead of 1/2hr as it is now?
Right now when I run my select query, it is returning the datatime as set in the db for every 1/2hr. What I am trying to do is run a query that will automaticaly add up the 1/2hr to 1hr. Example below: login name login time money_spent mimi 6:00-6:30 2.50 mimi 6.30-7:00 5.70
