Intrebari

Re: Autoincrement Field

Diana — Wed, 11 Mar 2009 12:39:49 GMT

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

Re: Autoincrement Field

xmldeveloper — Wed, 11 Mar 2009 09:54:24 GMT

http://www.databasejournal.com/features/mssql/article.php/10894_2244821_2/Sequential-NumberingCounting-of-Records-with-SQL-Server.htm
Vedeti sectiunea Sequentially Numbering Groups of Records.

Autoincrement Field

sorinh — Wed, 11 Mar 2009 09:51:42 GMT

Salut,

Am o intrebare legata de un cimp autoincrement care sa se reseteze in functie de o alta valoare:

select nr_comanda, produs, pozitie_comanda, sum(cantitate), client from
comenzi left join clienti
             left join produse
group by nr_comanda, produs, pozitie_comanda, client
order by comanda

ma inteereseaza ca la fiecare comanda sa pot numara produsele aferente ei. ex:
nrcomanda      produs       pozitie_comanda       client
    1                   apa                      1                  gigi
    1                 telefon                    2                  gigi
    1                   ciment                  3                  gigi
    2                     apa                    1                   fane
    2                     vodca                 2                   fane
    2                     cola                   3                     fane
    2                     pepsi                 4                       fane