JOIN ..... Column START <> Column END.
RRR
Ron Rose wrote:
>
> 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
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >
