http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/9498.aspxMon, 17 Dec 2012 18:41:13 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:9498ThePuiu0http://sqlserver.ro/forums/thread/9498.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=9498multumesc, mi-a fost de un real ajutor!http://sqlserver.ro/forums/thread/9497.aspxMon, 17 Dec 2012 05:31:46 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:9497rsocol0http://sqlserver.ro/forums/thread/9497.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=9497Dacă folosești SQL Server 2012, vezi: <a href="http://ole.michelsen.dk/blog/calculate-a-running-total-in-sql-server-2012/">http://ole.michelsen.dk/blog/calculate-a-running-total-in-sql-server-2012/</a> <br /> <br />Altfel, vezi: <a href="http://sqlserver.ro/forums/thread/7011.aspx">http://sqlserver.ro/forums/thread/7011.aspx</a> <br /> <br />Răzvanhttp://sqlserver.ro/forums/thread/9496.aspxSun, 16 Dec 2012 20:31:48 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:9496ThePuiu0http://sqlserver.ro/forums/thread/9496.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=9496Salut, nu stiu cum se numeste urmatoarea chestie ca as fi cautat pe net o rezolvare... Am un query care trebuie sa returneaza urmatoarele: <br />TIP,INTRARE,IESIRE,SOLD <br />0, 100,0, 100 <br />1, 0, 10, 90 <br />1,0,5,85 <br />cum trebuie sa generez coloana SOLD pt a obtine rezultatul ca in exemplu? (coloanele TIP,INTRARE si IESIRE exista ca rezultat al unui UNION si rezultatul incepe intotdeauna cu un record de tip 0 si un nr variabil de recorduri de tip 1). Multumesc!