Subject Re: [firebird-support] FIRST 1 of each iItemID
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