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

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.

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

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