Re: Exception in this sql

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.