Welcome to Sign in | Help

Re: Autoincrement Field

  •  03-11-2009, 2:39 PM

    Re: Autoincrement Field

    Daca lucrezi pe SQL 2005 poti incerca sa adaptezi acest exemplu (pentru care am folosit AdventureWorks)

    SELECT soh.SalesOrderID, sod.SalesOrderDetailID, sod.ProductID, sod.OrderQty,

    ROW_NUMBER() OVER (PARTITION BY soh.SalesOrderID ORDER BY sod.SalesOrderDetailID) AS Pos

    FROM Sales.SalesOrderHeader soh JOIN Sales.SalesOrderDetail sod

    ON soh.SalesOrderID = sod.SalesOrderID

     

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems