Re: Exception in this sql

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

Here is how I got it. Paul I told you to stop threatening me in private
emails, drunken cowboy.

CREATE VIEW rklib.clspaytp AS Select * from
 (
     Select x.*,
     row_number() over (partition by otord#
                        order by case ottrnc when '001' then 1 else 2 end
                        , ottrnd, ottrt
                        )
                     as RowN
    from rklib.clspaytpp x
) a
 where a.RowN in (1,2)


On Fri, May 22, 2015 at 10:31 AM, Paul Nelson <nelsonp@xxxxxxxxxxxxx> wrote:

> "Happy Memorial Day" ?????????????????????
>
> I would politely suggest that instead of your normal activities this
> weekend, you go visit one of the national cemeteries in Canada and the US,
> especially the more than 400,000 graves at Arlington, Virginia.
>
> Those men died to defend your right to forget your manners.
>
> Paul Nelson
> Cell 708-670-6978
> Office 409-267-4027
> nelsonp@xxxxxxxxxxxxx
>
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Hoteltravelfundotcom
> Sent: Friday, May 22, 2015 7:56 AM
> To: Midrange Systems Technical Discussion
> Subject: Re: Exception in this sql
>
> OK gotch, thanks Rob, lets not make a whole thing here, Happy Memorial day.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.