Row number creation

Hi,   I have a table like below   create table ##Test (Inv nvarchar(5), InvDate date) insert into ##Test values ('1001','2024-01-01') insert into ##Test values ('1001','2024-01-01') insert int...