Are you after the holes or the 1/2 hours? Column END NOT IN column START gives the holes (using a sub-select).
RRR Chuck Lockwood wrote: > > Without using a cursor, > given a table with time values: > > START END > 12:30 13:00 > 13:30 14:00 > 14:00 14:30 > 15:00 15:30 > > Is there an SQL way to return the empty slots: > 13:00 13:30 > 14:30 15:00 > > I'm thinking a view that starts with row 2 > joined with the table and sprinkled with a function > or two. Something weird like that! > > Any hopes? > > Chuck Lockwood > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > LockData Technologies, Inc. > 309 Main Avenue, Hawley, Pa 18428 > Phone: 570-226-7340 ~ Fax: 570-226-7341 > Email: [EMAIL PROTECTED] ~ http://www.lockdata.com > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >
