Thanks, Boris
I'll try it.
>>UPDATE YourTable SET YourColumn
FROM YourTable
INER JOIN (SELECT SoNo, AddDate, ROW_NUMBER() OVER (PARTITION BY Sono ORDER BY AddDate) AS RowNum
FROM YourTable) Tbl1
ON YourTable.SoNo = Tbl1.Sono AND
YourTable.AddDate = Tbl1.AddDate
NOT TESTED!!!!!!
Make a good backup before trying it :-)
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.