This is a great tip and I will use this in the future for sure!  Thank you!

Thank you this worked out great!

Yes I basically want the most recent price or last sales price, which would be the Max Start Date.

Thank you.

My end goal is to get the maximum PRM_StartDate for each Item ID.

For example:

SELECT IMA_ItemID, IMA_Price,PRD_UnitSalesPrice,PRM_StartDate FROM Item

LEFT JOIN PriceMatrix ON PRM_IMA_RecordID = IMA_RecordID

INNER JOIN PriceMatrixDetail ON PRD_PRM_RecordID = PRM_RecordID

WHERE...

Thank you.  I was able to import my flat file (CSV) to a table called CSVTest.  This CSV had the ItemID column and now an ItemStatusCode column with the value...

• This reply was modified 2 years, 8 months ago by  MP-iCONN.