|
nr
SQLTeam MVY
United Kingdom
12543 Posts |
 Posted - 09/26/2006 : 11:57:37
|
No idea what that means.
maybe
select t.name, t.count, 100.0 * t.count/x.val
from tbl t
cross join (select val = sum(count) from tbl) x
==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
 |
|
Percent
