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.
| Author |
Topic |
|
scottjon
Starting Member
3 Posts |
 Posted - 2012-04-02 : 07:27:01
|
| Hi, I am trying to sub-total headings from a custom function but not sure how to do.The function has the columns 1) Region2) Office3) PGroup4) No_of_Fee_earners5) Total_Last206) Average_Outstanding7) Total_Prior20 I would like to have rows to sub-total the columns; No_of_Fee_earners, Total_Last20, Average_Outstanding, Total_Prior20 when there is a change in Region or Practice Group and leave blank where there isn't a practice group.I have looked at the Rollup and Cube options but can't get to work.The current SQL that I have used for the custom function is select * from dbo.cf_missing_time_anal('01 Mar 2011','01 Apr 2012','27')Any help appreciated and I can provide more information if necessary. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-02 : 15:51:10
|
| can you show how should be sample output?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Sub-totaling