This may be a bit of an entry level question, but how do I create summary meta data?
I was looking for something like getting the latest price from a price list, SQL could be:
SELECT ItemId, Price, PriceDt from PRICES P1
where PriceDt = (SELECT max(P2.PriceDt) from PRICES P2 where P2.ItemId = P1.ItemId)
Any help would be much appreciated, even if it is just pointing me to the right friendly manual...