SELECT a.CustId, (a.Total / b.AbsoluteFinalTotal) * 100 FROM MyTable a, (SELECT SUM(Total) AS AbsoluteFinalTotal FROM MyTable) b;
Select Total, (Total* 100 / (Select sum(Total) From MyTable)) as Score From MyTable Group By Total
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)