Re: stuck with analytical job

From: bhonaker <bhonaker_at_gmail.com>
Date: Fri, 4 Nov 2011 07:24:29 -0700 (PDT)
Message-ID: <fce1a828-cdff-4a69-bf7d-12f2a6cea91b_at_h5g2000yqk.googlegroups.com>



On Nov 4, 9:33 am, yossarian <yossaria..._at_operamail.com> wrote:
> bhonaker wrote:
> > What piece of the row indicates the measure is non-compliant?
>
> All the measures are non-compliant. I only have to remove all the rows
> in a group except the first one because they are included in the time
> period defined by the first row. I separed groups with dashed lines in
> my first post.
>
> I solved the problem procedurally by writing a pipelined table function
> but I'm almost sure that this can be solved with SQL and analytic
> functions too.
>
> Thank you.
>
> Kind regards, Y.
>
> (sorry, I wrote to you a personal e-mail reply by mistake)

What part of the data indicates item 033398 had two series of noncompliant  measures other than the dashes you inserted in the output manually? Received on Fri Nov 04 2011 - 09:24:29 CDT

Original text of this message