|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1769 Posts |
 Posted - 02/24/2013 : 02:42:37
|
This would give you the answer, but overall ,if this is part of an application, i'd complete at the presentation layer
declare @total decimal(10,2),@part decimal (10,2)
set @total = 600
set @part = 430
select (100 /@total) * @part
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
 |
|
to find the division and result
