Hi Mark Thanks for that. What I have done is I have expanded the original cID with a yyyymmdd at the start of each value, so the dDt column is now not needed.
But still how can I get the rate attached to the top most dDt for each iItemID. Please advise Kind regards Bhavbhuti
