Sorry my mistake. it's 2005. Yes the invoice is incremental. I've tried using TOP predicate (SELECT Top 3...) but i only get 3 rows. It's the first time i'm using it so am not sure if my syntax is incorrect or what
CODE:
SELECT TOP (3) OrderDate, OrderNumber, OrderStatus, QuantityOrdered...