The function ROW_NUMBER was new to me. Thanks.

SELECT ROW_NUMBER() OVER(ORDER BY Agreement_Area_Id DESC) AS Row from dbo.Agreement_Area

Gives me the row numbers.

But to set Agreement_Area_Number = ROW_NUMBER() OVER(ORDER BY Agreement_Area_Id DESC) in an update statement is not legal.

So still - How to?

Best regards

Edvard Korsbæk