Viewing 3 posts - 1 through 4 (of 4 total)
that did the magic!
November 5, 2014 at 4:06 pm
#1756848
yes that was a good start,
The sorting is
(ROW_NUMBER() OVER(ORDER BY ol.OrdNo, ol.LnNo)
But the problem, it should start on 1 for each break in ol.OrdNo.
Example: see attached image.
Here is three...
November 5, 2014 at 3:49 pm
#1756838
deleted...
November 5, 2014 at 3:21 pm
#1756830