Was wondering if it's possible to use the rollup statement to create
percentages? For example, if I wanted a sales table that showed the
following

Region Salesman Total Sales %
US Jim 25 50
US Ron 25 50
US TOTAL 50 100

EUR Tony 15 25
EUR Shelly 30 50
EUR Jane 15 25
EUR TOTAL 60 100

I can use the With Rollup keyword to create the totals, is it possible to
also create the percentages?

Thanks,

Andrew

_________________________________________________________________
Get mobile Hotmail. Go to http://ninemsn.com.au/mobilecentral/signup.asp

MS Sql Server LazyDBA home page