I have read many messages regarding changing the sort order based on short_sp / far_sp and actual_sp but still cannot get a trigger to work as I expect. I would like to back / dutch the 1st three horses based on the SP price order during pre-OFF. I'm evaluating the product and would like assistance in creating this trigger.
Example
Back Price / SP
1. 2.3 / 3.4
2. 4.5 / 4.8
3. 6.3 / 2.1
4. 14 / 7
5. 4 / 2.9
Based on the above example I would like to dutch selections 3, 5, 1 at back prices of 6.3, 4.0 and 2.3.
thanks.