This seems to work

SELECT accountname,invoice_date, ROW_NUMBER()

OVER(PARTITION BY AccountName Order by INVOICE_DATE) as RankOrder from dbo.sagesales

where AccountName is not null

Insert help from above

But now I want to update a...