Calculate Mass/Weight - Most Advanced UOC

create function fn_calc_uoc_mass(@FromConversionUnit varchar(64),@ToConversionUnit varchar(64),@UnitValue float)
returns float
as
begin
--MASS

declare @returnvalue float

select @returnvalue = 
case 
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'gram' then @UnitValue * 1000.0
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'carat' then @UnitValue * 5000.0
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'centigram' then @UnitValue * 100000.0
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'decigram' then @UnitValue * 10000.0
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'dekagram' then @UnitValue * 100.0
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'hectogram' then @UnitValue * 10.0
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'milligram' then @UnitValue * 1000000.0
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'ounce' then @UnitValue * 35.27396194958041
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'pound' then @UnitValue * 2.204622621848776
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'short ton' then @UnitValue * 0.0011023113109244
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'stone' then @UnitValue * 0.1574730444177697
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'tonne' then @UnitValue * 0.001
when @FromConversionUnit = 'kilogram' and @ToConversionUnit = 'long ton' then @UnitValue * 0.00098420652761106

when @FromConversionUnit = 'gram' and @ToConversionUnit = 'kilogram' then @UnitValue * 0.001
when @FromConversionUnit = 'gram' and @ToConversionUnit = 'carat' then @UnitValue * 5.0
when @FromConversionUnit = 'gram' and @ToConversionUnit = 'centigram' then @UnitValue * 100.0
when @FromConversionUnit = 'gram' and @ToConversionUnit = 'decigram' then @UnitValue * 10.0
when @FromConversionUnit = 'gram' and @ToConversionUnit = 'dekagram' then @UnitValue * 0.1
when @FromConversionUnit = 'gram' and @ToConversionUnit = 'hectogram' then @UnitValue * 0.01
when @FromConversionUnit = 'gram' and @ToConversionUnit = 'milligram' then @UnitValue * 1000.0
when @FromConversionUnit = 'gram' and @ToConversionUnit = 'ounce' then @UnitValue * 0.0352739619495804
when @FromConversionUnit = 'gram' and @ToConversionUnit = 'pound' then @UnitValue * 0.0022046226218488
when @FromConversionUnit = 'gram' and @ToConversionUnit = 'short ton' then @UnitValue * 0.0000011023113109244
when @FromConversionUnit = 'gram' and @ToConversionUnit = 'stone' then @UnitValue * 0.0001574730444177697
when @FromConversionUnit = 'gram' and @ToConversionUnit = 'tonne' then @UnitValue * 0.000001
when @FromConversionUnit = 'gram' and @ToConversionUnit = 'long ton' then @UnitValue * 0.00000098420652761106

when @FromConversionUnit = 'carat' and @ToConversionUnit = 'kilogram' then @UnitValue * 0.0002
when @FromConversionUnit = 'carat' and @ToConversionUnit = 'gram' then @UnitValue * 0.2
when @FromConversionUnit = 'carat' and @ToConversionUnit = 'centigram' then @UnitValue * 20.0
when @FromConversionUnit = 'carat' and @ToConversionUnit = 'decigram' then @UnitValue * 2.0
when @FromConversionUnit = 'carat' and @ToConversionUnit = 'dekagram' then @UnitValue * 0.02
when @FromConversionUnit = 'carat' and @ToConversionUnit = 'hectogram' then @UnitValue * 0.002
when @FromConversionUnit = 'carat' and @ToConversionUnit = 'milligram' then @UnitValue * 200.0
when @FromConversionUnit = 'carat' and @ToConversionUnit = 'ounce' then @UnitValue * 0.0070547923899161
when @FromConversionUnit = 'carat' and @ToConversionUnit = 'pound' then @UnitValue * 0.00044092452436976
when @FromConversionUnit = 'carat' and @ToConversionUnit = 'short ton' then @UnitValue * 0.00000022046226218488
when @FromConversionUnit = 'carat' and @ToConversionUnit = 'stone' then @UnitValue * 0.000031494608883554
when @FromConversionUnit = 'carat' and @ToConversionUnit = 'tonne' then @UnitValue * 0.0000002
when @FromConversionUnit = 'carat' and @ToConversionUnit = 'long ton' then @UnitValue * 0.00000019684130552221

when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'kilogram' then @UnitValue * 0.00001
when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'gram' then @UnitValue * 0.01
when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'carat' then @UnitValue * 0.05
when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'decigram' then @UnitValue * 0.1
when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'dekagram' then @UnitValue * 0.001
when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'hectogram' then @UnitValue * 0.0001
when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'milligram' then @UnitValue * 10.0
when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'ounce' then @UnitValue * 0.0003527396194958
when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'pound' then @UnitValue * 0.000022046226218488
when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'short ton' then @UnitValue * 0.000000011023113109244
when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'stone' then @UnitValue * 0.000001574730444177697
when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'tonne' then @UnitValue * 0.00000001
when @FromConversionUnit = 'centigram' and @ToConversionUnit = 'long ton' then @UnitValue * 0.0000000098420652761106

when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'kilogram' then @UnitValue * 0.0001
when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'gram' then @UnitValue * 0.1
when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'carat' then @UnitValue * 0.5
when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'centigram' then @UnitValue * 10.0
when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'dekagram' then @UnitValue * 0.01
when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'hectogram' then @UnitValue * 0.001
when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'milligram' then @UnitValue * 100.0
when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'ounce' then @UnitValue * 0.003527396194958
when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'pound' then @UnitValue * 0.00022046226218488
when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'short ton' then @UnitValue * 0.00000011023113109244
when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'stone' then @UnitValue * 0.00001574730444177697
when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'tonne' then @UnitValue * 0.0000001
when @FromConversionUnit = 'decigram' and @ToConversionUnit = 'long ton' then @UnitValue * 0.0000000984206527611061

when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'kilogram' then @UnitValue * 0.01
when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'gram' then @UnitValue * 10.0
when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'carat' then @UnitValue * 50.0
when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'centigram' then @UnitValue * 1000.0
when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'decigram' then @UnitValue * 100.0
when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'hectogram' then @UnitValue * 0.1
when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'milligram' then @UnitValue * 10000.0
when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'ounce' then @UnitValue * 0.3527396194958041
when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'pound' then @UnitValue * 0.0220462262184878
when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'short ton' then @UnitValue * 0.000011023113109244
when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'stone' then @UnitValue * 0.001574730444177697
when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'tonne' then @UnitValue * 0.00001
when @FromConversionUnit = 'dekagram' and @ToConversionUnit = 'long ton' then @UnitValue * 0.000009842065276110606

when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'kilogram' then @UnitValue * 0.1
when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'gram' then @UnitValue * 100.0
when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'carat' then @UnitValue * 500.0
when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'centigram' then @UnitValue * 10000.0
when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'decigram' then @UnitValue * 1000.0
when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'dekagram' then @UnitValue * 10.0
when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'milligram' then @UnitValue * 100000.0
when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'ounce' then @UnitValue * 3.527396194958041
when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'pound' then @UnitValue * 0.2204622621848776
when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'short ton' then @UnitValue * 0.00011023113109244
when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'stone' then @UnitValue * 0.015747304441777
when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'tonne' then @UnitValue * 0.0001
when @FromConversionUnit = 'hectogram' and @ToConversionUnit = 'long ton' then @UnitValue * 0.00009842065276110606

when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'kilogram' then @UnitValue * 0.000001
when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'gram' then @UnitValue * 0.001
when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'carat' then @UnitValue * 0.005
when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'centigram' then @UnitValue * 0.1
when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'decigram' then @UnitValue * 0.01
when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'dekagram' then @UnitValue * 0.0001
when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'hectogram' then @UnitValue * 0.00001
when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'ounce' then @UnitValue * 0.00003527396194958
when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'pound' then @UnitValue * 0.0000022046226218488
when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'short ton' then @UnitValue * 0.0000000011023113109244
when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'stone' then @UnitValue * 0.0000001574730444177697
when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'tonne' then @UnitValue * 0.000000001
when @FromConversionUnit = 'milligram' and @ToConversionUnit = 'long ton' then @UnitValue * 0.00000000098420652761106

when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'kilogram' then @UnitValue * 0.028349523125
when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'gram' then @UnitValue * 28.349523125
when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'carat' then @UnitValue * 141.747615625
when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'centigram' then @UnitValue * 2834.9523125
when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'decigram' then @UnitValue * 283.49523125
when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'dekagram' then @UnitValue * 2.8349523125
when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'hectogram' then @UnitValue * 0.28349523125
when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'milligram' then @UnitValue * 28349.523125
when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'pound' then @UnitValue * 0.0625
when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'short ton' then @UnitValue * 0.00003125
when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'stone' then @UnitValue * 0.0044642857142857
when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'tonne' then @UnitValue * 0.000028349523125
when @FromConversionUnit = 'ounce' and @ToConversionUnit = 'long ton' then @UnitValue * 0.00002790178571428571

when @FromConversionUnit = 'pound' and @ToConversionUnit = 'kilogram' then @UnitValue * 0.45359237
when @FromConversionUnit = 'pound' and @ToConversionUnit = 'gram' then @UnitValue * 453.59237
when @FromConversionUnit = 'pound' and @ToConversionUnit = 'carat' then @UnitValue * 2267.96185
when @FromConversionUnit = 'pound' and @ToConversionUnit = 'centigram' then @UnitValue * 45359.237
when @FromConversionUnit = 'pound' and @ToConversionUnit = 'decigram' then @UnitValue * 4535.9237
when @FromConversionUnit = 'pound' and @ToConversionUnit = 'dekagram' then @UnitValue * 45.359237
when @FromConversionUnit = 'pound' and @ToConversionUnit = 'hectogram' then @UnitValue * 4.5359237
when @FromConversionUnit = 'pound' and @ToConversionUnit = 'milligram' then @UnitValue * 453592.37
when @FromConversionUnit = 'pound' and @ToConversionUnit = 'ounce' then @UnitValue * 16.0
when @FromConversionUnit = 'pound' and @ToConversionUnit = 'short ton' then @UnitValue * 0.0005
when @FromConversionUnit = 'pound' and @ToConversionUnit = 'stone' then @UnitValue * 0.0714285714285714
when @FromConversionUnit = 'pound' and @ToConversionUnit = 'tonne' then @UnitValue * 0.00045359237
when @FromConversionUnit = 'pound' and @ToConversionUnit = 'long ton' then @UnitValue * 0.00044642857142857

when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'kilogram' then @UnitValue * 907.18474
when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'gram' then @UnitValue * 907184.74
when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'carat' then @UnitValue * 4535923.7
when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'centigram' then @UnitValue * 90718474.0
when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'decigram' then @UnitValue * 9071847.4
when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'dekagram' then @UnitValue * 90718.474
when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'hectogram' then @UnitValue * 9071.8474
when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'milligram' then @UnitValue * 907184740.0
when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'ounce' then @UnitValue * 32000.0
when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'pound' then @UnitValue * 2000.0
when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'stone' then @UnitValue * 142.8571428571429
when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'tonne' then @UnitValue * 0.90718474
when @FromConversionUnit = 'short ton' and @ToConversionUnit = 'long ton' then @UnitValue * 0.8928571428571429

when @FromConversionUnit = 'stone' and @ToConversionUnit = 'kilogram' then @UnitValue * 6.35029318
when @FromConversionUnit = 'stone' and @ToConversionUnit = 'gram' then @UnitValue * 6350.29318
when @FromConversionUnit = 'stone' and @ToConversionUnit = 'carat' then @UnitValue * 31751.4659
when @FromConversionUnit = 'stone' and @ToConversionUnit = 'centigram' then @UnitValue * 635029.318
when @FromConversionUnit = 'stone' and @ToConversionUnit = 'decigram' then @UnitValue * 63502.9318
when @FromConversionUnit = 'stone' and @ToConversionUnit = 'dekagram' then @UnitValue * 635.029318
when @FromConversionUnit = 'stone' and @ToConversionUnit = 'hectogram' then @UnitValue * 63.5029318
when @FromConversionUnit = 'stone' and @ToConversionUnit = 'milligram' then @UnitValue * 6350293.18
when @FromConversionUnit = 'stone' and @ToConversionUnit = 'ounce' then @UnitValue * 224.0
when @FromConversionUnit = 'stone' and @ToConversionUnit = 'pound' then @UnitValue * 14.0
when @FromConversionUnit = 'stone' and @ToConversionUnit = 'short ton' then @UnitValue * 0.007
when @FromConversionUnit = 'stone' and @ToConversionUnit = 'tonne' then @UnitValue * 0.00635029318
when @FromConversionUnit = 'stone' and @ToConversionUnit = 'long ton' then @UnitValue * 0.00625

when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'kilogram' then @UnitValue * 1000.0
when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'gram' then @UnitValue * 1000000.0
when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'carat' then @UnitValue * 5000000.0
when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'centigram' then @UnitValue * 100000000.0
when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'decigram' then @UnitValue * 10000000.0
when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'dekagram' then @UnitValue * 100000.0
when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'hectogram' then @UnitValue * 10000.0
when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'milligram' then @UnitValue * 1000000000
when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'ounce' then @UnitValue * 35273.96194958041
when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'pound' then @UnitValue * 2204.622621848776
when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'short ton' then @UnitValue * 1.102311310924388
when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'stone' then @UnitValue * 157.4730444177697
when @FromConversionUnit = 'tonne' and @ToConversionUnit = 'long ton' then @UnitValue * 0.9842065276110606

when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'kilogram' then @UnitValue * 1016.0469088
when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'gram' then @UnitValue * 1016046.9088
when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'carat' then @UnitValue * 5080234.544
when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'centigram' then @UnitValue * 101604690.88
when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'decigram' then @UnitValue * 10160469.088
when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'dekagram' then @UnitValue * 101604.69088
when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'hectogram' then @UnitValue * 10160.469088
when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'milligram' then @UnitValue * 1016046908.8
when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'ounce' then @UnitValue * 35840.0
when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'pound' then @UnitValue * 2240.0
when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'short ton' then @UnitValue * 1.12
when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'stone' then @UnitValue * 160.0
when @FromConversionUnit = 'long ton' and @ToConversionUnit = 'tonne' then @UnitValue * 1.0160469088

when @FromConversionUnit = @ToConversionUnit then @UnitValue * 1.0
end

return(@returnvalue)

end
go



--examples
select dbo.fn_calc_uoc_mass('kilogram','gram',10)
select dbo.fn_calc_uoc_mass('kilogram','carat',10)
select dbo.fn_calc_uoc_mass('kilogram','centigram',10)
select dbo.fn_calc_uoc_mass('kilogram','decigram',10)
select dbo.fn_calc_uoc_mass('kilogram','dekagram',10)
select dbo.fn_calc_uoc_mass('kilogram','hectogram',10)
select dbo.fn_calc_uoc_mass('kilogram','milligram',10)
select dbo.fn_calc_uoc_mass('kilogram','ounce',10)
select dbo.fn_calc_uoc_mass('kilogram','pound',10)
select dbo.fn_calc_uoc_mass('kilogram','short ton',10)
select dbo.fn_calc_uoc_mass('kilogram','stone',10)
select dbo.fn_calc_uoc_mass('kilogram','tonne',10)
select dbo.fn_calc_uoc_mass('kilogram','long ton',10)
   
select dbo.fn_calc_uoc_mass('gram','kilogram',10)
select dbo.fn_calc_uoc_mass('gram','carat',10)
select dbo.fn_calc_uoc_mass('gram','centigram',10)
select dbo.fn_calc_uoc_mass('gram','decigram',10)
select dbo.fn_calc_uoc_mass('gram','dekagram',10)
select dbo.fn_calc_uoc_mass('gram','hectogram',10)
select dbo.fn_calc_uoc_mass('gram','milligram',10)
select dbo.fn_calc_uoc_mass('gram','ounce',10)
select dbo.fn_calc_uoc_mass('gram','pound',10)
select dbo.fn_calc_uoc_mass('gram','short ton',10)
select dbo.fn_calc_uoc_mass('gram','stone',10)
select dbo.fn_calc_uoc_mass('gram','tonne',10)
select dbo.fn_calc_uoc_mass('gram','long ton',10)

select dbo.fn_calc_uoc_mass('carat','kilogram',10)
select dbo.fn_calc_uoc_mass('carat','gram',10)
select dbo.fn_calc_uoc_mass('carat','centigram',10)
select dbo.fn_calc_uoc_mass('carat','decigram',10)
select dbo.fn_calc_uoc_mass('carat','dekagram',10)
select dbo.fn_calc_uoc_mass('carat','hectogram',10)
select dbo.fn_calc_uoc_mass('carat','milligram',10)
select dbo.fn_calc_uoc_mass('carat','ounce',10)
select dbo.fn_calc_uoc_mass('carat','pound',10)
select dbo.fn_calc_uoc_mass('carat','short ton',10)
select dbo.fn_calc_uoc_mass('carat','stone',10)
select dbo.fn_calc_uoc_mass('carat','tonne',10)
select dbo.fn_calc_uoc_mass('carat','long ton',10)

select dbo.fn_calc_uoc_mass('centigram','kilogram',10)
select dbo.fn_calc_uoc_mass('centigram','gram',10)
select dbo.fn_calc_uoc_mass('centigram','carat',10)
select dbo.fn_calc_uoc_mass('centigram','decigram',10)
select dbo.fn_calc_uoc_mass('centigram','dekagram',10)
select dbo.fn_calc_uoc_mass('centigram','hectogram',10)
select dbo.fn_calc_uoc_mass('centigram','milligram',10)
select dbo.fn_calc_uoc_mass('centigram','ounce',10)
select dbo.fn_calc_uoc_mass('centigram','pound',10)
select dbo.fn_calc_uoc_mass('centigram','short ton',10)
select dbo.fn_calc_uoc_mass('centigram','stone',10)
select dbo.fn_calc_uoc_mass('centigram','tonne',10)
select dbo.fn_calc_uoc_mass('centigram','long ton',10)

select dbo.fn_calc_uoc_mass('decigram','kilogram',10)
select dbo.fn_calc_uoc_mass('decigram','gram',10)
select dbo.fn_calc_uoc_mass('decigram','carat',10)
select dbo.fn_calc_uoc_mass('decigram','centigram',10)
select dbo.fn_calc_uoc_mass('decigram','dekagram',10)
select dbo.fn_calc_uoc_mass('decigram','hectogram',10)
select dbo.fn_calc_uoc_mass('decigram','milligram',10)
select dbo.fn_calc_uoc_mass('decigram','ounce',10)
select dbo.fn_calc_uoc_mass('decigram','pound',10)
select dbo.fn_calc_uoc_mass('decigram','short ton',10)
select dbo.fn_calc_uoc_mass('decigram','stone',10)
select dbo.fn_calc_uoc_mass('decigram','tonne',10)
select dbo.fn_calc_uoc_mass('decigram','long ton',10)

select dbo.fn_calc_uoc_mass('dekagram','kilogram',10)
select dbo.fn_calc_uoc_mass('dekagram','gram',10)
select dbo.fn_calc_uoc_mass('dekagram','carat',10)
select dbo.fn_calc_uoc_mass('dekagram','centigram',10)
select dbo.fn_calc_uoc_mass('dekagram','decigram',10)
select dbo.fn_calc_uoc_mass('dekagram','hectogram',10)
select dbo.fn_calc_uoc_mass('dekagram','milligram',10)
select dbo.fn_calc_uoc_mass('dekagram','ounce',10)
select dbo.fn_calc_uoc_mass('dekagram','pound',10)
select dbo.fn_calc_uoc_mass('dekagram','short ton',10)
select dbo.fn_calc_uoc_mass('dekagram','stone',10)
select dbo.fn_calc_uoc_mass('dekagram','tonne',10)
select dbo.fn_calc_uoc_mass('dekagram','long ton',10)

select dbo.fn_calc_uoc_mass('hectogram','kilogram',10)
select dbo.fn_calc_uoc_mass('hectogram','gram',10)
select dbo.fn_calc_uoc_mass('hectogram','carat',10)
select dbo.fn_calc_uoc_mass('hectogram','centigram',10)
select dbo.fn_calc_uoc_mass('hectogram','decigram',10)
select dbo.fn_calc_uoc_mass('hectogram','dekagram',10)
select dbo.fn_calc_uoc_mass('hectogram','milligram',10)
select dbo.fn_calc_uoc_mass('hectogram','ounce',10)
select dbo.fn_calc_uoc_mass('hectogram','pound',10)
select dbo.fn_calc_uoc_mass('hectogram','short ton',10)
select dbo.fn_calc_uoc_mass('hectogram','stone',10)
select dbo.fn_calc_uoc_mass('hectogram','tonne',10)
select dbo.fn_calc_uoc_mass('hectogram','long ton',10)

select dbo.fn_calc_uoc_mass('milligram','kilogram',10)
select dbo.fn_calc_uoc_mass('milligram','gram',10)
select dbo.fn_calc_uoc_mass('milligram','carat',10)
select dbo.fn_calc_uoc_mass('milligram','centigram',10)
select dbo.fn_calc_uoc_mass('milligram','decigram',10)
select dbo.fn_calc_uoc_mass('milligram','dekagram',10)
select dbo.fn_calc_uoc_mass('milligram','hectogram',10)
select dbo.fn_calc_uoc_mass('milligram','ounce',10)
select dbo.fn_calc_uoc_mass('milligram','pound',10)
select dbo.fn_calc_uoc_mass('milligram','short ton',10)
select dbo.fn_calc_uoc_mass('milligram','stone',10)
select dbo.fn_calc_uoc_mass('milligram','tonne',10)
select dbo.fn_calc_uoc_mass('milligram','long ton',10)

select dbo.fn_calc_uoc_mass('ounce','kilogram',10)
select dbo.fn_calc_uoc_mass('ounce','gram',10)
select dbo.fn_calc_uoc_mass('ounce','carat',10)
select dbo.fn_calc_uoc_mass('ounce','centigram',10)
select dbo.fn_calc_uoc_mass('ounce','decigram',10)
select dbo.fn_calc_uoc_mass('ounce','dekagram',10)
select dbo.fn_calc_uoc_mass('ounce','hectogram',10)
select dbo.fn_calc_uoc_mass('ounce','milligram',10)
select dbo.fn_calc_uoc_mass('ounce','pound',10)
select dbo.fn_calc_uoc_mass('ounce','short ton',10)
select dbo.fn_calc_uoc_mass('ounce','stone',10)
select dbo.fn_calc_uoc_mass('ounce','tonne',10)
select dbo.fn_calc_uoc_mass('ounce','long ton',10)

select dbo.fn_calc_uoc_mass('pound','kilogram',10)
select dbo.fn_calc_uoc_mass('pound','gram',10)
select dbo.fn_calc_uoc_mass('pound','carat',10)
select dbo.fn_calc_uoc_mass('pound','centigram',10)
select dbo.fn_calc_uoc_mass('pound','decigram',10)
select dbo.fn_calc_uoc_mass('pound','dekagram',10)
select dbo.fn_calc_uoc_mass('pound','hectogram',10)
select dbo.fn_calc_uoc_mass('pound','milligram',10)
select dbo.fn_calc_uoc_mass('pound','ounce',10)
select dbo.fn_calc_uoc_mass('pound','short ton',10)
select dbo.fn_calc_uoc_mass('pound','stone',10)
select dbo.fn_calc_uoc_mass('pound','tonne',10)
select dbo.fn_calc_uoc_mass('pound','long ton',10)

select dbo.fn_calc_uoc_mass('short ton','kilogram',10)
select dbo.fn_calc_uoc_mass('short ton','gram',10)
select dbo.fn_calc_uoc_mass('short ton','carat',10)
select dbo.fn_calc_uoc_mass('short ton','centigram',10)
select dbo.fn_calc_uoc_mass('short ton','decigram',10)
select dbo.fn_calc_uoc_mass('short ton','dekagram',10)
select dbo.fn_calc_uoc_mass('short ton','hectogram',10)
select dbo.fn_calc_uoc_mass('short ton','milligram',10)
select dbo.fn_calc_uoc_mass('short ton','ounce',10)
select dbo.fn_calc_uoc_mass('short ton','pound',10)
select dbo.fn_calc_uoc_mass('short ton','stone',10)
select dbo.fn_calc_uoc_mass('short ton','tonne',10)
select dbo.fn_calc_uoc_mass('short ton','long ton',10)

select dbo.fn_calc_uoc_mass('stone','kilogram',10)
select dbo.fn_calc_uoc_mass('stone','gram',10)
select dbo.fn_calc_uoc_mass('stone','carat',10)
select dbo.fn_calc_uoc_mass('stone','centigram',10)
select dbo.fn_calc_uoc_mass('stone','decigram',10)
select dbo.fn_calc_uoc_mass('stone','dekagram',10)
select dbo.fn_calc_uoc_mass('stone','hectogram',10)
select dbo.fn_calc_uoc_mass('stone','milligram',10)
select dbo.fn_calc_uoc_mass('stone','ounce',10)
select dbo.fn_calc_uoc_mass('stone','pound',10)
select dbo.fn_calc_uoc_mass('stone','short ton',10)
select dbo.fn_calc_uoc_mass('stone','tonne',10)
select dbo.fn_calc_uoc_mass('stone','long ton',10)

select dbo.fn_calc_uoc_mass('tonne','kilogram',10)
select dbo.fn_calc_uoc_mass('tonne','gram',10)
select dbo.fn_calc_uoc_mass('tonne','carat',10)
select dbo.fn_calc_uoc_mass('tonne','centigram',10)
select dbo.fn_calc_uoc_mass('tonne','decigram',10)
select dbo.fn_calc_uoc_mass('tonne','dekagram',10)
select dbo.fn_calc_uoc_mass('tonne','hectogram',10)
select dbo.fn_calc_uoc_mass('tonne','milligram',10)
select dbo.fn_calc_uoc_mass('tonne','ounce',10)
select dbo.fn_calc_uoc_mass('tonne','pound',10)
select dbo.fn_calc_uoc_mass('tonne','short ton',10)
select dbo.fn_calc_uoc_mass('tonne','stone',10)
select dbo.fn_calc_uoc_mass('tonne','long ton',10)

select dbo.fn_calc_uoc_mass('long ton','kilogram',10)
select dbo.fn_calc_uoc_mass('long ton','gram',10)
select dbo.fn_calc_uoc_mass('long ton','carat',10)
select dbo.fn_calc_uoc_mass('long ton','centigram',10)
select dbo.fn_calc_uoc_mass('long ton','decigram',10)
select dbo.fn_calc_uoc_mass('long ton','dekagram',10)
select dbo.fn_calc_uoc_mass('long ton','hectogram',10)
select dbo.fn_calc_uoc_mass('long ton','milligram',10)
select dbo.fn_calc_uoc_mass('long ton','ounce',10)
select dbo.fn_calc_uoc_mass('long ton','pound',10)
select dbo.fn_calc_uoc_mass('long ton','short ton',10)
select dbo.fn_calc_uoc_mass('long ton','stone',10)
select dbo.fn_calc_uoc_mass('long ton','tonne',10)