Here is my sample table and data.
Create table #TempInvoice
id int identity (1,1),
Insert into #TempInvoice (Tkey,Status,Amount)
Select * from #TempInvoice
Drop table #TempInvoice
However, Here what I want in my select statement.
I want to just add the last row with same information just changing the status to "First" any advice? The amount could be coming from Top 1