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
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)