Can anyone assist me with an issue I'm having?
The following sql query works with SQL server. I'm having problems replicating this against a Progress 10.1 database. The specific clause is " row_number() OVER (PARTITION BY st.Custno ORDER BY st.ShipTo) AS CustomerSequence
" which returns an integer based on how many ST rows returned for a custno.
This is the definition of the Over clause:
Determines the partitioning and ordering of the rowset before the associated window function is applied.
Here is the link: http://msdn.microsoft.com/en-us/library/ms189461.aspx
Does anyone have suggestions on how to accomplish this with a progress database? I have referred to OpenEdge® Data Management: SQL Reference with no luck.
Sample Query:
select st.custno as CustomerNumber, st.name as Contact, st.custtype AS CustomerType,
row_number() OVER (PARTITION BY st.Custno ORDER BY st.ShipTo) AS CustomerSequence
from pub.arss st