Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Overlapping Times
Yeah, I got to that point, but I can't allow gaps in the vents to be counted along with the event hours. This is where I started scratching my head and thinking that I can't do this just with SQL -
SQL - limit no. of rows returned.....
you can also use SELECT TOP 100 as your select statemnt. I'm not sure if the TOP keword is an ANSI standard or just in T-SQL though -
Overlapping Times
Ok, I have a table that stores information on events. It has a Date field for the day the event takes place and a StartTime and an EndTime field that track when the event starts and ends. Now, I wrote a simple SQL statement that gives me the total hours for each event by subtracting the...
