>

>SELECT * FROM InvoiceTemp
> WHERE InvoiceTemp.RowNumberbetween 2 and RowTotal AND InvoiceTemp.NoStatus=7

>
>However, this query will not select only consecutive last rows, it will select all rows except the very last one with the particular status. I need to think more about how to transform this query to only get consecutive last rows with that status and not all rows with that status if this is what you're after.

Yes, I will follow up on the most recent message.