From a select statement I want to generate a unique line number (increments of 10000) for every record returned.
select ?? as [LineNO], Customer from Customers
If the Customer table had 5 records I want the following returned.