Viewing 2 posts - 1 through 2 (of 2 total)
Not sure what you mean by Weight in the Detail table. is that the % of allocation? or actual quantity to be allocated. what do you mean by 33 in...
March 21, 2012 at 2:33 am
#1462044
In most of the cases you need to retain the latest record from the duplicates. In that case matching rank=rownumber will not work.
So using ROW_NUMBER() partition and ORDER BY col...
July 27, 2010 at 12:29 pm
#1198901