Re: table with sparce data

Mikito Harakiri wrote:

> "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3F467C80.23D4957D_at_exxesolutions.com...
> > An analytic
> > function might do the job but it would be more trouble than it would be
> > worth. If I understand the OP's thing I could write the code in 7
> > minutes.
>
> Let me make clear, that this is not a routine assignment that I want to
> complete quickly and efficiently. In that case, I would truly consider
> procedural solution, program it, report to my boss, and forget about it.
> Learn nothing from it, as well. I'm interested to know how this query can be
> expressed in SQL.

AFAIK it can't be. Which doesn't mean Joe Celko couldn't puzzle it out. But it would be 100% dependent upon a single definition of ordering. If you are really interested in this for academic purposes send an email to Celko and ask him to help you.

Them, if you would be so kind, post the solution for us to admire.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)