Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 tsql column groups addding problem

Author  Topic 

routernix
Starting Member

1 Post

Posted - 2011-06-04 : 02:50:30
static field and column groups fields sum how?

sample picture..



problem : oldamount add monthamount for column group

oldamount + monthamount ( month 01)
oldamount + monthamount ( month 02)
oldamount + monthamount ( month 03) etc..

please help me..
thanks.
routers



visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-06-05 : 03:46:31
are you looking for running total?
if yes, see below (scenario 1)

http://visakhm.blogspot.com/2010/01/multipurpose-apply-operator.html


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -