WITH Members AS ( select ROW_NUMBER() OVER (ORDER BY OrderID DESC) as row, OrderDate, OrderId, ShipName, ShipPostalCode from dbo.Orders ) Select row, OrderDate, OrderId, ShipName, ShipPostalCode from Members
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)