Update A Column based on results of another column
Posted on 2013-11-26
In the same table "PropertyCalcs", I am try to update a column based a minimum value of another column.
I have PropertyID, OrderNumber, and First Inspection Date as columns.
For each ProptertyID, I need SQL to find the min(OrderNumber) and then write 'First Inspection Date' in the First Inspection Date column, when it finds the minimum OrderNumber for that PropertyID.
If you have any questions, please let me know and I'll be happy to answer them.