Technical Article

Calculate Volume - Most Advanced UOC

,

This function is used to calculate the actual unit of conversion for volume.

This is a most advanced generic function , which suppose to return values for 182 combinations.

Regards,

Vignesh Arulmani

create function fn_calc_uoc_volume(@FromConversionUnit varchar(64),@ToConversionUnit varchar(64),@UnitValue float)
returns float
as
begin

--VOLUME


declare @returnvalue float

select @returnvalue = 
case 
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'cubic feet' then @UnitValue * 3.531466672148859e-5
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'cubic inch' then @UnitValue * 0.0610237440947323
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.000001
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'cubic yard' then @UnitValue * 1.307950619314392e-6
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 0.035195079727854
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 0.033814022701843
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 2.199692482990878e-4
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'gallon - US' then @UnitValue * 2.641720523581484e-4
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'liter' then @UnitValue * 0.001
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'pint - UK' then @UnitValue * 0.0017597539863927
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'pint - US' then @UnitValue * 0.0021133764188652
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'quart - UK' then @UnitValue * 8.798769931963512e-4
when @FromConversionUnit = 'cubic centimeter' and @ToConversionUnit = 'quart - US' then @UnitValue * 0.0010566882094326

when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 28316.846592
when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'cubic inch' then @UnitValue * 1728.0
when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.028316846592
when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'cubic yard' then @UnitValue * 0.037037037037037
when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 996.6136734468521
when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 957.5064935064935
when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 6.228835459042826
when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'gallon - US' then @UnitValue * 7.480519480519481
when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'liter' then @UnitValue * 28.316846592
when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'pint - UK' then @UnitValue * 49.83068367234261
when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'pint - US' then @UnitValue * 59.84415584415584
when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'quart - UK' then @UnitValue * 24.9153418361713
when @FromConversionUnit = 'cubic feet' and @ToConversionUnit = 'quart - US' then @UnitValue * 29.92207792207792

when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 16.387064
when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'cubic feet' then @UnitValue * 5.787037037037037e-4
when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.000016387064
when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'cubic yard' then @UnitValue * 2.143347050754458e-5
when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 0.5767440239854468
when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 0.5541125541125541
when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 0.003604650149909
when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'gallon - US' then @UnitValue * 0.0043290043290043
when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'liter' then @UnitValue * 0.016387064
when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'pint - UK' then @UnitValue * 0.0288372011992723
when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'pint - US' then @UnitValue * 0.0346320346320346
when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'quart - UK' then @UnitValue * 0.0144186005996362
when @FromConversionUnit = 'cubic inch' and @ToConversionUnit = 'quart - US' then @UnitValue * 0.0173160173160173

when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 1000000.0
when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'cubic feet' then @UnitValue * 35.31466672148859
when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'cubic inch' then @UnitValue * 61023.74409473228
when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'cubic yard' then @UnitValue * 1.307950619314392
when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 35195.07972785405
when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 33814.022701843
when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 219.9692482990878
when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'gallon - US' then @UnitValue * 264.1720523581484
when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'liter' then @UnitValue * 1000.0
when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'pint - UK' then @UnitValue * 1759.753986392702
when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'pint - US' then @UnitValue * 2113.376418865187
when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'quart - UK' then @UnitValue * 879.8769931963512
when @FromConversionUnit = 'cubic meter' and @ToConversionUnit = 'quart - US' then @UnitValue * 1056.688209432594

when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 764554.857984
when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'cubic feet' then @UnitValue * 27.0
when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'cubic inch' then @UnitValue * 46656.0
when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.764554857984
when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 26908.56918306501
when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 25852.67532467532
when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 168.1785573941563
when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'gallon - US' then @UnitValue * 201.974025974026
when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'liter' then @UnitValue * 764.554857984
when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'pint - UK' then @UnitValue * 1345.42845915325
when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'pint - US' then @UnitValue * 1615.792207792208
when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'quart - UK' then @UnitValue * 672.7142295766252
when @FromConversionUnit = 'cubic yard' and @ToConversionUnit = 'quart - US' then @UnitValue * 807.8961038961039

when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 28.4130625
when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'cubic feet' then @UnitValue * 0.0010033978327243
when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'cubic inch' then @UnitValue * 1.733871454947634
when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.0000284130625
when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'cubic yard' then @UnitValue * 3.716288269349353e-5
when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 0.9607599404038839
when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 0.00625
when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'gallon - US' then @UnitValue * 0.0075059370344053
when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'liter' then @UnitValue * 0.0284130625
when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'pint - UK' then @UnitValue * 0.05
when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'pint - US' then @UnitValue * 0.0600474962752427
when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'quart - UK' then @UnitValue * 0.025
when @FromConversionUnit = 'fluid ounce - UK' and @ToConversionUnit = 'quart - US' then @UnitValue * 0.0300237481376214

when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 29.5735295625
when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'cubic feet' then @UnitValue * 0.0010443793402778
when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'cubic inch' then @UnitValue * 1.8046875
when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.0000295735295625
when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'cubic yard' then @UnitValue * 3.868071630658436e-5
when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 1.040842730786236
when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 0.006505267067414
when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'gallon - US' then @UnitValue * 0.0078125
when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'liter' then @UnitValue * 0.0295735295625
when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'pint - UK' then @UnitValue * 0.0520421365393118
when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'pint - US' then @UnitValue * 0.0625
when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'quart - UK' then @UnitValue * 0.0260210682696559
when @FromConversionUnit = 'fluid ounce - US' and @ToConversionUnit = 'quart - US' then @UnitValue * 0.03125

when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 4546.09
when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'cubic feet' then @UnitValue * 0.1605436532358921
when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'cubic inch' then @UnitValue * 277.4194327916215
when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.00454609
when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'cubic yard' then @UnitValue * 0.005946061230959
when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 160.0
when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 153.7215904646214
when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'gallon - US' then @UnitValue * 1.200949925504855
when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'liter' then @UnitValue * 4.54609
when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'pint - UK' then @UnitValue * 8.0
when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'pint - US' then @UnitValue * 9.607599404038839
when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'quart - UK' then @UnitValue * 4.0
when @FromConversionUnit = 'gallon - UK' and @ToConversionUnit = 'quart - US' then @UnitValue * 4.80379970201942

when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 3785.411784
when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'cubic feet' then @UnitValue * 0.1336805555555556
when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'cubic inch' then @UnitValue * 231.0
when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.003785411784
when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'cubic yard' then @UnitValue * 0.0049511316872428
when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 133.2278695406382
when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 128.0
when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 0.8326741846289889
when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'liter' then @UnitValue * 3.785411784
when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'pint - UK' then @UnitValue * 6.661393477031911
when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'pint - US' then @UnitValue * 8.0
when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'quart - UK' then @UnitValue * 3.330696738515955
when @FromConversionUnit = 'gallon - US' and @ToConversionUnit = 'quart - US' then @UnitValue * 4.0

when @FromConversionUnit = 'liter' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 1000.0
when @FromConversionUnit = 'liter' and @ToConversionUnit = 'cubic feet' then @UnitValue * 0.0353146667214886
when @FromConversionUnit = 'liter' and @ToConversionUnit = 'cubic inch' then @UnitValue * 61.02374409473228
when @FromConversionUnit = 'liter' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.001
when @FromConversionUnit = 'liter' and @ToConversionUnit = 'cubic yard' then @UnitValue * 0.0013079506193144
when @FromConversionUnit = 'liter' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 35.19507972785405
when @FromConversionUnit = 'liter' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 33.814022701843
when @FromConversionUnit = 'liter' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 0.2199692482990878
when @FromConversionUnit = 'liter' and @ToConversionUnit = 'gallon - US' then @UnitValue * 0.2641720523581484
when @FromConversionUnit = 'liter' and @ToConversionUnit = 'pint - UK' then @UnitValue * 1.759753986392702
when @FromConversionUnit = 'liter' and @ToConversionUnit = 'pint - US' then @UnitValue * 2.113376418865187
when @FromConversionUnit = 'liter' and @ToConversionUnit = 'quart - UK' then @UnitValue * 0.8798769931963512
when @FromConversionUnit = 'liter' and @ToConversionUnit = 'quart - US' then @UnitValue * 1.056688209432594

when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 568.26125
when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'cubic feet' then @UnitValue * 0.0200679566544865
when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'cubic inch' then @UnitValue * 34.67742909895269
when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.00056826125
when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'cubic yard' then @UnitValue * 7.432576538698707e-4
when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 20.0
when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 19.21519880807768
when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 0.125
when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'gallon - US' then @UnitValue * 0.1501187406881069
when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'liter' then @UnitValue * 0.56826125
when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'pint - US' then @UnitValue * 1.200949925504855
when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'quart - UK' then @UnitValue * 0.5
when @FromConversionUnit = 'pint - UK' and @ToConversionUnit = 'quart - US' then @UnitValue * 0.6004749627524275

when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 473.176473
when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'cubic feet' then @UnitValue * 0.0167100694444444
when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'cubic inch' then @UnitValue * 28.875
when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.000473176473
when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'cubic yard' then @UnitValue * 6.188914609053498e-4
when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 16.65348369257978
when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 16.0
when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 0.1040842730786236
when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'gallon - US' then @UnitValue * 0.125
when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'liter' then @UnitValue * 0.473176473
when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'pint - UK' then @UnitValue * 0.8326741846289889
when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'quart - UK' then @UnitValue * 0.4163370923144944
when @FromConversionUnit = 'pint - US' and @ToConversionUnit = 'quart - US' then @UnitValue * 0.5

when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 1136.5225
when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'cubic feet' then @UnitValue * 0.040135913308973
when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'cubic inch' then @UnitValue * 69.35485819790537
when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.0011365225
when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'cubic yard' then @UnitValue * 0.0014865153077397
when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 40.0
when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 38.43039761615536
when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 0.25
when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'gallon - US' then @UnitValue * 0.3002374813762137
when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'liter' then @UnitValue * 1.1365225
when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'pint - UK' then @UnitValue * 2.0
when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'pint - US' then @UnitValue * 2.40189985100971
when @FromConversionUnit = 'quart - UK' and @ToConversionUnit = 'quart - US' then @UnitValue * 1.200949925504855

when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'cubic centimeter' then @UnitValue * 946.352946
when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'cubic feet' then @UnitValue * 0.0334201388888889
when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'cubic inch' then @UnitValue * 57.75
when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'cubic meter' then @UnitValue * 0.000946352946
when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'cubic yard' then @UnitValue * 0.0012377829218107
when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'fluid ounce - UK' then @UnitValue * 33.30696738515955
when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'fluid ounce - US' then @UnitValue * 32.0
when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'gallon - UK' then @UnitValue * 0.2081685461572472
when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'gallon - US' then @UnitValue * 0.25
when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'liter' then @UnitValue * 0.946352946
when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'pint - UK' then @UnitValue * 1.665348369257978
when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'pint - US' then @UnitValue * 2.0
when @FromConversionUnit = 'quart - US' and @ToConversionUnit = 'quart - UK' then @UnitValue * 0.8326741846289889

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

return(@returnvalue)

end
go



--examples
select dbo.fn_calc_uoc_volume('cubic centimeter','cubic feet',10)
select dbo.fn_calc_uoc_volume('cubic centimeter','cubic inch',10)
select dbo.fn_calc_uoc_volume('cubic centimeter','cubic meter',10)
select dbo.fn_calc_uoc_volume('cubic centimeter','cubic yard',10)
select dbo.fn_calc_uoc_volume('cubic centimeter','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('cubic centimeter','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('cubic centimeter','gallon - UK',10)
select dbo.fn_calc_uoc_volume('cubic centimeter','gallon - US',10)
select dbo.fn_calc_uoc_volume('cubic centimeter','liter',10)
select dbo.fn_calc_uoc_volume('cubic centimeter','pint - UK',10)
select dbo.fn_calc_uoc_volume('cubic centimeter','pint - US',10)
select dbo.fn_calc_uoc_volume('cubic centimeter','quart - UK',10)
select dbo.fn_calc_uoc_volume('cubic centimeter','quart - US',10)

select dbo.fn_calc_uoc_volume('cubic feet','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('cubic feet','cubic inch',10)
select dbo.fn_calc_uoc_volume('cubic feet','cubic meter',10)
select dbo.fn_calc_uoc_volume('cubic feet','cubic yard',10)
select dbo.fn_calc_uoc_volume('cubic feet','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('cubic feet','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('cubic feet','gallon - UK',10)
select dbo.fn_calc_uoc_volume('cubic feet','gallon - US',10)
select dbo.fn_calc_uoc_volume('cubic feet','liter',10)
select dbo.fn_calc_uoc_volume('cubic feet','pint - UK',10)
select dbo.fn_calc_uoc_volume('cubic feet','pint - US',10)
select dbo.fn_calc_uoc_volume('cubic feet','quart - UK',10)
select dbo.fn_calc_uoc_volume('cubic feet','quart - US',10)

select dbo.fn_calc_uoc_volume('cubic inch','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('cubic inch','cubic feet',10)
select dbo.fn_calc_uoc_volume('cubic inch','cubic meter',10)
select dbo.fn_calc_uoc_volume('cubic inch','cubic yard',10)
select dbo.fn_calc_uoc_volume('cubic inch','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('cubic inch','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('cubic inch','gallon - UK',10)
select dbo.fn_calc_uoc_volume('cubic inch','gallon - US',10)
select dbo.fn_calc_uoc_volume('cubic inch','liter',10)
select dbo.fn_calc_uoc_volume('cubic inch','pint - UK',10)
select dbo.fn_calc_uoc_volume('cubic inch','pint - US',10)
select dbo.fn_calc_uoc_volume('cubic inch','quart - UK',10)
select dbo.fn_calc_uoc_volume('cubic inch','quart - US',10)

select dbo.fn_calc_uoc_volume('cubic meter','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('cubic meter','cubic feet',10)
select dbo.fn_calc_uoc_volume('cubic meter','cubic inch',10)
select dbo.fn_calc_uoc_volume('cubic meter','cubic yard',10)
select dbo.fn_calc_uoc_volume('cubic meter','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('cubic meter','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('cubic meter','gallon - UK',10)
select dbo.fn_calc_uoc_volume('cubic meter','gallon - US',10)
select dbo.fn_calc_uoc_volume('cubic meter','liter',10)
select dbo.fn_calc_uoc_volume('cubic meter','pint - UK',10)
select dbo.fn_calc_uoc_volume('cubic meter','pint - US',10)
select dbo.fn_calc_uoc_volume('cubic meter','quart - UK',10)
select dbo.fn_calc_uoc_volume('cubic meter','quart - US',10)

select dbo.fn_calc_uoc_volume('cubic yard','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('cubic yard','cubic feet',10)
select dbo.fn_calc_uoc_volume('cubic yard','cubic inch',10)
select dbo.fn_calc_uoc_volume('cubic yard','cubic meter',10)
select dbo.fn_calc_uoc_volume('cubic yard','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('cubic yard','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('cubic yard','gallon - UK',10)
select dbo.fn_calc_uoc_volume('cubic yard','gallon - US',10)
select dbo.fn_calc_uoc_volume('cubic yard','liter',10)
select dbo.fn_calc_uoc_volume('cubic yard','pint - UK',10)
select dbo.fn_calc_uoc_volume('cubic yard','pint - US',10)
select dbo.fn_calc_uoc_volume('cubic yard','quart - UK',10)
select dbo.fn_calc_uoc_volume('cubic yard','quart - US',10)

select dbo.fn_calc_uoc_volume('fluid ounce - UK','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('fluid ounce - UK','cubic feet',10)
select dbo.fn_calc_uoc_volume('fluid ounce - UK','cubic inch',10)
select dbo.fn_calc_uoc_volume('fluid ounce - UK','cubic meter',10)
select dbo.fn_calc_uoc_volume('fluid ounce - UK','cubic yard',10)
select dbo.fn_calc_uoc_volume('fluid ounce - UK','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('fluid ounce - UK','gallon - UK',10)
select dbo.fn_calc_uoc_volume('fluid ounce - UK','gallon - US',10)
select dbo.fn_calc_uoc_volume('fluid ounce - UK','liter',10)
select dbo.fn_calc_uoc_volume('fluid ounce - UK','pint - UK',10)
select dbo.fn_calc_uoc_volume('fluid ounce - UK','pint - US',10)
select dbo.fn_calc_uoc_volume('fluid ounce - UK','quart - UK',10)
select dbo.fn_calc_uoc_volume('fluid ounce - UK','quart - US',10)

select dbo.fn_calc_uoc_volume('fluid ounce - US','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('fluid ounce - US','cubic feet',10)
select dbo.fn_calc_uoc_volume('fluid ounce - US','cubic inch',10)
select dbo.fn_calc_uoc_volume('fluid ounce - US','cubic meter',10)
select dbo.fn_calc_uoc_volume('fluid ounce - US','cubic yard',10)
select dbo.fn_calc_uoc_volume('fluid ounce - US','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('fluid ounce - US','gallon - UK',10)
select dbo.fn_calc_uoc_volume('fluid ounce - US','gallon - US',10)
select dbo.fn_calc_uoc_volume('fluid ounce - US','liter',10)
select dbo.fn_calc_uoc_volume('fluid ounce - US','pint - UK',10)
select dbo.fn_calc_uoc_volume('fluid ounce - US','pint - US',10)
select dbo.fn_calc_uoc_volume('fluid ounce - US','quart - UK',10)
select dbo.fn_calc_uoc_volume('fluid ounce - US','quart - US',10)

select dbo.fn_calc_uoc_volume('gallon - UK','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('gallon - UK','cubic feet',10)
select dbo.fn_calc_uoc_volume('gallon - UK','cubic inch',10)
select dbo.fn_calc_uoc_volume('gallon - UK','cubic meter',10)
select dbo.fn_calc_uoc_volume('gallon - UK','cubic yard',10)
select dbo.fn_calc_uoc_volume('gallon - UK','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('gallon - UK','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('gallon - UK','gallon - US',10)
select dbo.fn_calc_uoc_volume('gallon - UK','liter',10)
select dbo.fn_calc_uoc_volume('gallon - UK','pint - UK',10)
select dbo.fn_calc_uoc_volume('gallon - UK','pint - US',10)
select dbo.fn_calc_uoc_volume('gallon - UK','quart - UK',10)
select dbo.fn_calc_uoc_volume('gallon - UK','quart - US',10)

select dbo.fn_calc_uoc_volume('gallon - US','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('gallon - US','cubic feet',10)
select dbo.fn_calc_uoc_volume('gallon - US','cubic inch',10)
select dbo.fn_calc_uoc_volume('gallon - US','cubic meter',10)
select dbo.fn_calc_uoc_volume('gallon - US','cubic yard',10)
select dbo.fn_calc_uoc_volume('gallon - US','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('gallon - US','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('gallon - US','gallon - UK',10)
select dbo.fn_calc_uoc_volume('gallon - US','liter',10)
select dbo.fn_calc_uoc_volume('gallon - US','pint - UK',10)
select dbo.fn_calc_uoc_volume('gallon - US','pint - US',10)
select dbo.fn_calc_uoc_volume('gallon - US','quart - UK',10)
select dbo.fn_calc_uoc_volume('gallon - US','quart - US',10)

select dbo.fn_calc_uoc_volume('liter','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('liter','cubic feet',10)
select dbo.fn_calc_uoc_volume('liter','cubic inch',10)
select dbo.fn_calc_uoc_volume('liter','cubic meter',10)
select dbo.fn_calc_uoc_volume('liter','cubic yard',10)
select dbo.fn_calc_uoc_volume('liter','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('liter','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('liter','gallon - UK',10)
select dbo.fn_calc_uoc_volume('liter','gallon - US',10)
select dbo.fn_calc_uoc_volume('liter','pint - UK',10)
select dbo.fn_calc_uoc_volume('liter','pint - US',10)
select dbo.fn_calc_uoc_volume('liter','quart - UK',10)
select dbo.fn_calc_uoc_volume('liter','quart - US',10)

select dbo.fn_calc_uoc_volume('pint - UK','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('pint - UK','cubic feet',10)
select dbo.fn_calc_uoc_volume('pint - UK','cubic inch',10)
select dbo.fn_calc_uoc_volume('pint - UK','cubic meter',10)
select dbo.fn_calc_uoc_volume('pint - UK','cubic yard',10)
select dbo.fn_calc_uoc_volume('pint - UK','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('pint - UK','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('pint - UK','gallon - UK',10)
select dbo.fn_calc_uoc_volume('pint - UK','gallon - US',10)
select dbo.fn_calc_uoc_volume('pint - UK','liter',10)
select dbo.fn_calc_uoc_volume('pint - UK','pint - US',10)
select dbo.fn_calc_uoc_volume('pint - UK','quart - UK',10)
select dbo.fn_calc_uoc_volume('pint - UK','quart - US',10)

select dbo.fn_calc_uoc_volume('pint - US','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('pint - US','cubic feet',10)
select dbo.fn_calc_uoc_volume('pint - US','cubic inch',10)
select dbo.fn_calc_uoc_volume('pint - US','cubic meter',10)
select dbo.fn_calc_uoc_volume('pint - US','cubic yard',10)
select dbo.fn_calc_uoc_volume('pint - US','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('pint - US','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('pint - US','gallon - UK',10)
select dbo.fn_calc_uoc_volume('pint - US','gallon - US',10)
select dbo.fn_calc_uoc_volume('pint - US','liter',10)
select dbo.fn_calc_uoc_volume('pint - US','pint - UK',10)
select dbo.fn_calc_uoc_volume('pint - US','quart - UK',10)
select dbo.fn_calc_uoc_volume('pint - US','quart - US',10)

select dbo.fn_calc_uoc_volume('quart - UK','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('quart - UK','cubic feet',10)
select dbo.fn_calc_uoc_volume('quart - UK','cubic inch',10)
select dbo.fn_calc_uoc_volume('quart - UK','cubic meter',10)
select dbo.fn_calc_uoc_volume('quart - UK','cubic yard',10)
select dbo.fn_calc_uoc_volume('quart - UK','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('quart - UK','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('quart - UK','gallon - UK',10)
select dbo.fn_calc_uoc_volume('quart - UK','gallon - US',10)
select dbo.fn_calc_uoc_volume('quart - UK','liter',10)
select dbo.fn_calc_uoc_volume('quart - UK','pint - UK',10)
select dbo.fn_calc_uoc_volume('quart - UK','pint - US',10)
select dbo.fn_calc_uoc_volume('quart - UK','quart - US',10)

select dbo.fn_calc_uoc_volume('quart - US','cubic centimeter',10)
select dbo.fn_calc_uoc_volume('quart - US','cubic feet',10)
select dbo.fn_calc_uoc_volume('quart - US','cubic inch',10)
select dbo.fn_calc_uoc_volume('quart - US','cubic meter',10)
select dbo.fn_calc_uoc_volume('quart - US','cubic yard',10)
select dbo.fn_calc_uoc_volume('quart - US','fluid ounce - UK',10)
select dbo.fn_calc_uoc_volume('quart - US','fluid ounce - US',10)
select dbo.fn_calc_uoc_volume('quart - US','gallon - UK',10)
select dbo.fn_calc_uoc_volume('quart - US','gallon - US',10)
select dbo.fn_calc_uoc_volume('quart - US','liter',10)
select dbo.fn_calc_uoc_volume('quart - US','pint - UK',10)
select dbo.fn_calc_uoc_volume('quart - US','pint - US',10)
select dbo.fn_calc_uoc_volume('quart - US','quart - UK',10)

Rate

1 (5)

You rated this post out of 5. Change rating

Share

Share

Rate

1 (5)

You rated this post out of 5. Change rating