T-SQL Unit Of Conversion for 1026 Combinations

Create function fn_calc_uoc_allinone(@UnitConversionType varchar(32),@FromConversionUnit varchar(64),@ToConversionUnit varchar(64),@UnitValue float)
returns float
as
begin
/*
Prerequisites :
You need to get the base functions from below URLs
fn_calc_uoc_angle       - http://www.sqlservercentral.com/scripts/unit+of+conversion/119873/
fn_calc_uoc_area        - http://www.sqlservercentral.com/scripts/unit+of+conversion/119871/
fn_calc_uoc_energy      - http://www.sqlservercentral.com/scripts/unit+of+conversion/119876/
fn_calc_uoc_length      - http://www.sqlservercentral.com/scripts/unit+of+conversion/120030/
fn_calc_uoc_mass        - http://www.sqlservercentral.com/scripts/unit+of+conversion/119837/
fn_calc_uoc_power       - http://www.sqlservercentral.com/scripts/unit+of+conversion/120098/
fn_calc_uoc_pressure    - http://www.sqlservercentral.com/scripts/unit+of+conversion/119928/
fn_calc_uoc_temperature - http://www.sqlservercentral.com/scripts/unit+of+conversion/119881/
fn_calc_uoc_time        - http://www.sqlservercentral.com/scripts/unit+of+conversion/120090/
fn_calc_uoc_velocity    - http://www.sqlservercentral.com/scripts/unit+of+conversion/119927/
fn_calc_uoc_volume      - http://www.sqlservercentral.com/scripts/unit+of+conversion/120094/
*/

declare @returnvalue float

select @returnvalue =
case
    when @UnitConversionType = 'angle' then dbo.fn_calc_uoc_angle(@FromConversionUnit,@ToConversionUnit,@UnitValue)
    when @UnitConversionType = 'area' then dbo.fn_calc_uoc_area(@FromConversionUnit,@ToConversionUnit,@UnitValue)
    when @UnitConversionType = 'energy' then dbo.fn_calc_uoc_energy(@FromConversionUnit,@ToConversionUnit,@UnitValue)
    when @UnitConversionType = 'length' then dbo.fn_calc_uoc_length(@FromConversionUnit,@ToConversionUnit,@UnitValue)
    when @UnitConversionType = 'mass' then dbo.fn_calc_uoc_mass(@FromConversionUnit,@ToConversionUnit,@UnitValue)
    when @UnitConversionType = 'power' then dbo.fn_calc_uoc_power(@FromConversionUnit,@ToConversionUnit,@UnitValue)
    when @UnitConversionType = 'pressure' then dbo.fn_calc_uoc_pressure(@FromConversionUnit,@ToConversionUnit,@UnitValue)
    when @UnitConversionType = 'temperature' then dbo.fn_calc_uoc_temperature(@FromConversionUnit,@ToConversionUnit,@UnitValue)
    when @UnitConversionType = 'time' then dbo.fn_calc_uoc_time(@FromConversionUnit,@ToConversionUnit,@UnitValue)
    when @UnitConversionType = 'velocity' then dbo.fn_calc_uoc_velocity(@FromConversionUnit,@ToConversionUnit,@UnitValue)
    when @UnitConversionType = 'volume' then dbo.fn_calc_uoc_volume(@FromConversionUnit,@ToConversionUnit,@UnitValue)

end

return(@returnvalue)

end
go


--examples
--Angle 6 combinations
select dbo.fn_calc_uoc_allinone('angle','degree','gradian',10)
select dbo.fn_calc_uoc_allinone('angle','degree','radian',10)

select dbo.fn_calc_uoc_allinone('angle','gradian','degree',10)
select dbo.fn_calc_uoc_allinone('angle','gradian','radian',10)

select dbo.fn_calc_uoc_allinone('angle','radian','degree',10)
select dbo.fn_calc_uoc_allinone('angle','radian','gradian',10)



--Area 132 combinations
select dbo.fn_calc_uoc_allinone('area','acres','hectares',10)
select dbo.fn_calc_uoc_allinone('area','acres','sqcm',10)
select dbo.fn_calc_uoc_allinone('area','acres','sqft',10)
select dbo.fn_calc_uoc_allinone('area','acres','sqinch',10)
select dbo.fn_calc_uoc_allinone('area','acres','sqkm',10)
select dbo.fn_calc_uoc_allinone('area','acres','sqmt',10)
select dbo.fn_calc_uoc_allinone('area','acres','sqmi',10)
select dbo.fn_calc_uoc_allinone('area','acres','sqmm',10)
select dbo.fn_calc_uoc_allinone('area','acres','sqyd',10)
select dbo.fn_calc_uoc_allinone('area','acres','cent',10)
select dbo.fn_calc_uoc_allinone('area','acres','ground',10)

select dbo.fn_calc_uoc_allinone('area','hectares','acres',10)
select dbo.fn_calc_uoc_allinone('area','hectares','sqcm',10)
select dbo.fn_calc_uoc_allinone('area','hectares','sqft',10)
select dbo.fn_calc_uoc_allinone('area','hectares','sqinch',10)
select dbo.fn_calc_uoc_allinone('area','hectares','sqkm',10)
select dbo.fn_calc_uoc_allinone('area','hectares','sqmt',10)
select dbo.fn_calc_uoc_allinone('area','hectares','sqmi',10)
select dbo.fn_calc_uoc_allinone('area','hectares','sqmm',10)
select dbo.fn_calc_uoc_allinone('area','hectares','sqyd',10)
select dbo.fn_calc_uoc_allinone('area','hectares','cent',10)
select dbo.fn_calc_uoc_allinone('area','hectares','ground',10)

select dbo.fn_calc_uoc_allinone('area','sqcm','acres',10)
select dbo.fn_calc_uoc_allinone('area','sqcm','hectares',10)
select dbo.fn_calc_uoc_allinone('area','sqcm','sqft',10)
select dbo.fn_calc_uoc_allinone('area','sqcm','sqinch',10)
select dbo.fn_calc_uoc_allinone('area','sqcm','sqkm',10)
select dbo.fn_calc_uoc_allinone('area','sqcm','sqmt',10)
select dbo.fn_calc_uoc_allinone('area','sqcm','sqmi',10)
select dbo.fn_calc_uoc_allinone('area','sqcm','sqmm',10)
select dbo.fn_calc_uoc_allinone('area','sqcm','sqyd',10)
select dbo.fn_calc_uoc_allinone('area','sqcm','cent',10)
select dbo.fn_calc_uoc_allinone('area','sqcm','ground',10)

select dbo.fn_calc_uoc_allinone('area','sqft','acres',10)
select dbo.fn_calc_uoc_allinone('area','sqft','hectares',10)
select dbo.fn_calc_uoc_allinone('area','sqft','sqcm',10)
select dbo.fn_calc_uoc_allinone('area','sqft','sqinch',10)
select dbo.fn_calc_uoc_allinone('area','sqft','sqkm',10)
select dbo.fn_calc_uoc_allinone('area','sqft','sqmt',10)
select dbo.fn_calc_uoc_allinone('area','sqft','sqmi',10)
select dbo.fn_calc_uoc_allinone('area','sqft','sqmm',10)
select dbo.fn_calc_uoc_allinone('area','sqft','sqyd',10)
select dbo.fn_calc_uoc_allinone('area','sqft','cent',10)
select dbo.fn_calc_uoc_allinone('area','sqft','ground',10)

select dbo.fn_calc_uoc_allinone('area','sqinch','acres',10)
select dbo.fn_calc_uoc_allinone('area','sqinch','hectares',10)
select dbo.fn_calc_uoc_allinone('area','sqinch','sqcm',10)
select dbo.fn_calc_uoc_allinone('area','sqinch','sqft',10)
select dbo.fn_calc_uoc_allinone('area','sqinch','sqkm',10)
select dbo.fn_calc_uoc_allinone('area','sqinch','sqmt',10)
select dbo.fn_calc_uoc_allinone('area','sqinch','sqmi',10)
select dbo.fn_calc_uoc_allinone('area','sqinch','sqmm',10)
select dbo.fn_calc_uoc_allinone('area','sqinch','sqyd',10)
select dbo.fn_calc_uoc_allinone('area','sqinch','cent',10)
select dbo.fn_calc_uoc_allinone('area','sqinch','ground',10)

select dbo.fn_calc_uoc_allinone('area','sqkm','acres',10)
select dbo.fn_calc_uoc_allinone('area','sqkm','hectares',10)
select dbo.fn_calc_uoc_allinone('area','sqkm','sqcm',10)
select dbo.fn_calc_uoc_allinone('area','sqkm','sqft',10)
select dbo.fn_calc_uoc_allinone('area','sqkm','sqinch',10)
select dbo.fn_calc_uoc_allinone('area','sqkm','sqmt',10)
select dbo.fn_calc_uoc_allinone('area','sqkm','sqmi',10)
select dbo.fn_calc_uoc_allinone('area','sqkm','sqmm',10)
select dbo.fn_calc_uoc_allinone('area','sqkm','sqyd',10)
select dbo.fn_calc_uoc_allinone('area','sqkm','cent',10)
select dbo.fn_calc_uoc_allinone('area','sqkm','ground',10)

select dbo.fn_calc_uoc_allinone('area','sqmt','acres',10)
select dbo.fn_calc_uoc_allinone('area','sqmt','hectares',10)
select dbo.fn_calc_uoc_allinone('area','sqmt','sqcm',10)
select dbo.fn_calc_uoc_allinone('area','sqmt','sqft',10)
select dbo.fn_calc_uoc_allinone('area','sqmt','sqinch',10)
select dbo.fn_calc_uoc_allinone('area','sqmt','sqkm',10)
select dbo.fn_calc_uoc_allinone('area','sqmt','sqmi',10)
select dbo.fn_calc_uoc_allinone('area','sqmt','sqmm',10)
select dbo.fn_calc_uoc_allinone('area','sqmt','sqyd',10)
select dbo.fn_calc_uoc_allinone('area','sqmt','cent',10)
select dbo.fn_calc_uoc_allinone('area','sqmt','ground',10)

select dbo.fn_calc_uoc_allinone('area','sqmi','acres',10)
select dbo.fn_calc_uoc_allinone('area','sqmi','hectares',10)
select dbo.fn_calc_uoc_allinone('area','sqmi','sqcm',10)
select dbo.fn_calc_uoc_allinone('area','sqmi','sqft',10)
select dbo.fn_calc_uoc_allinone('area','sqmi','sqinch',10)
select dbo.fn_calc_uoc_allinone('area','sqmi','sqkm',10)
select dbo.fn_calc_uoc_allinone('area','sqmi','sqmt',10)
select dbo.fn_calc_uoc_allinone('area','sqmi','sqmm',10)
select dbo.fn_calc_uoc_allinone('area','sqmi','sqyd',10)
select dbo.fn_calc_uoc_allinone('area','sqmi','cent',10)
select dbo.fn_calc_uoc_allinone('area','sqmi','ground',10)

select dbo.fn_calc_uoc_allinone('area','sqmm','acres',10)
select dbo.fn_calc_uoc_allinone('area','sqmm','hectares',10)
select dbo.fn_calc_uoc_allinone('area','sqmm','sqcm',10)
select dbo.fn_calc_uoc_allinone('area','sqmm','sqft',10)
select dbo.fn_calc_uoc_allinone('area','sqmm','sqinch',10)
select dbo.fn_calc_uoc_allinone('area','sqmm','sqkm',10)
select dbo.fn_calc_uoc_allinone('area','sqmm','sqmt',10)
select dbo.fn_calc_uoc_allinone('area','sqmm','sqmi',10)
select dbo.fn_calc_uoc_allinone('area','sqmm','sqyd',10)
select dbo.fn_calc_uoc_allinone('area','sqmm','cent',10)
select dbo.fn_calc_uoc_allinone('area','sqmm','ground',10)

select dbo.fn_calc_uoc_allinone('area','sqyd','acres',10)
select dbo.fn_calc_uoc_allinone('area','sqyd','hectares',10)
select dbo.fn_calc_uoc_allinone('area','sqyd','sqcm',10)
select dbo.fn_calc_uoc_allinone('area','sqyd','sqft',10)
select dbo.fn_calc_uoc_allinone('area','sqyd','sqinch',10)
select dbo.fn_calc_uoc_allinone('area','sqyd','sqkm',10)
select dbo.fn_calc_uoc_allinone('area','sqyd','sqmt',10)
select dbo.fn_calc_uoc_allinone('area','sqyd','sqmi',10)
select dbo.fn_calc_uoc_allinone('area','sqyd','sqmm',10)
select dbo.fn_calc_uoc_allinone('area','sqyd','cent',10)
select dbo.fn_calc_uoc_allinone('area','sqyd','ground',10)

select dbo.fn_calc_uoc_allinone('area','cent','acres',10)
select dbo.fn_calc_uoc_allinone('area','cent','hectares',10)
select dbo.fn_calc_uoc_allinone('area','cent','sqcm',10)
select dbo.fn_calc_uoc_allinone('area','cent','sqft',10)
select dbo.fn_calc_uoc_allinone('area','cent','sqinch',10)
select dbo.fn_calc_uoc_allinone('area','cent','sqkm',10)
select dbo.fn_calc_uoc_allinone('area','cent','sqmt',10)
select dbo.fn_calc_uoc_allinone('area','cent','sqmi',10)
select dbo.fn_calc_uoc_allinone('area','cent','sqmm',10)
select dbo.fn_calc_uoc_allinone('area','cent','sqyd',10)
select dbo.fn_calc_uoc_allinone('area','cent','ground',10)

select dbo.fn_calc_uoc_allinone('area','ground','acres',10)
select dbo.fn_calc_uoc_allinone('area','ground','hectares',10)
select dbo.fn_calc_uoc_allinone('area','ground','sqcm',10)
select dbo.fn_calc_uoc_allinone('area','ground','sqft',10)
select dbo.fn_calc_uoc_allinone('area','ground','sqinch',10)
select dbo.fn_calc_uoc_allinone('area','ground','sqkm',10)
select dbo.fn_calc_uoc_allinone('area','ground','sqmt',10)
select dbo.fn_calc_uoc_allinone('area','ground','sqmi',10)
select dbo.fn_calc_uoc_allinone('area','ground','sqmm',10)
select dbo.fn_calc_uoc_allinone('area','ground','sqyd',10)
select dbo.fn_calc_uoc_allinone('area','ground','cent',10)


--Energy 42 combinations
select dbo.fn_calc_uoc_allinone('energy','BTU','C',10)
select dbo.fn_calc_uoc_allinone('energy','BTU','EV',10)
select dbo.fn_calc_uoc_allinone('energy','BTU','FP',10)
select dbo.fn_calc_uoc_allinone('energy','BTU','J',10)
select dbo.fn_calc_uoc_allinone('energy','BTU','KC',10)
select dbo.fn_calc_uoc_allinone('energy','BTU','KJ',10)

select dbo.fn_calc_uoc_allinone('energy','C','BTU',10)
select dbo.fn_calc_uoc_allinone('energy','C','EV',10)
select dbo.fn_calc_uoc_allinone('energy','C','FP',10)
select dbo.fn_calc_uoc_allinone('energy','C','J',10)
select dbo.fn_calc_uoc_allinone('energy','C','KC',10)
select dbo.fn_calc_uoc_allinone('energy','C','KJ',10)

select dbo.fn_calc_uoc_allinone('energy','EV','BTU',10)
select dbo.fn_calc_uoc_allinone('energy','EV','C',10)
select dbo.fn_calc_uoc_allinone('energy','EV','FP',10)
select dbo.fn_calc_uoc_allinone('energy','EV','J',10)
select dbo.fn_calc_uoc_allinone('energy','EV','KC',10)
select dbo.fn_calc_uoc_allinone('energy','EV','KJ',10)

select dbo.fn_calc_uoc_allinone('energy','FP','BTU',10)
select dbo.fn_calc_uoc_allinone('energy','FP','C',10)
select dbo.fn_calc_uoc_allinone('energy','FP','EV',10)
select dbo.fn_calc_uoc_allinone('energy','FP','J',10)
select dbo.fn_calc_uoc_allinone('energy','FP','KC',10)
select dbo.fn_calc_uoc_allinone('energy','FP','KJ',10)

select dbo.fn_calc_uoc_allinone('energy','J','BTU',10)
select dbo.fn_calc_uoc_allinone('energy','J','C',10)
select dbo.fn_calc_uoc_allinone('energy','J','EV',10)
select dbo.fn_calc_uoc_allinone('energy','J','FP',10)
select dbo.fn_calc_uoc_allinone('energy','J','KC',10)
select dbo.fn_calc_uoc_allinone('energy','J','KJ',10)

select dbo.fn_calc_uoc_allinone('energy','KC','BTU',10)
select dbo.fn_calc_uoc_allinone('energy','KC','C',10)
select dbo.fn_calc_uoc_allinone('energy','KC','EV',10)
select dbo.fn_calc_uoc_allinone('energy','KC','FP',10)
select dbo.fn_calc_uoc_allinone('energy','KC','J',10)
select dbo.fn_calc_uoc_allinone('energy','KC','KJ',10)

select dbo.fn_calc_uoc_allinone('energy','KJ','BTU',10)
select dbo.fn_calc_uoc_allinone('energy','KJ','C',10)
select dbo.fn_calc_uoc_allinone('energy','KJ','EV',10)
select dbo.fn_calc_uoc_allinone('energy','KJ','FP',10)
select dbo.fn_calc_uoc_allinone('energy','KJ','J',10)
select dbo.fn_calc_uoc_allinone('energy','KJ','KC',10)




--Length 342 combinations
select dbo.fn_calc_uoc_allinone('length','angstrom','centimeters' ,10)
select dbo.fn_calc_uoc_allinone('length','angstrom','chain',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','fathom',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','feet',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','hand',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','inch',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','kilometers' ,10)
select dbo.fn_calc_uoc_allinone('length','angstrom','link',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','meter',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','microns',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','mile',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','millimeters',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','angstrom','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','pica',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','rods',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','span',10)
select dbo.fn_calc_uoc_allinone('length','angstrom','yard',10)

select dbo.fn_calc_uoc_allinone('length','centimeters','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','centimeters','chain',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','fathom',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','feet',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','hand',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','inch',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','kilometers' ,10)
select dbo.fn_calc_uoc_allinone('length','centimeters','link',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','meter',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','microns',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','mile',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','millimeters',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','centimeters','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','pica',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','rods',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','span',10)
select dbo.fn_calc_uoc_allinone('length','centimeters','yard',10)

select dbo.fn_calc_uoc_allinone('length','chain','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','chain','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','chain','fathom',10)
select dbo.fn_calc_uoc_allinone('length','chain','feet',10)
select dbo.fn_calc_uoc_allinone('length','chain','hand',10)
select dbo.fn_calc_uoc_allinone('length','chain','inch',10)
select dbo.fn_calc_uoc_allinone('length','chain','kilometers' ,10)
select dbo.fn_calc_uoc_allinone('length','chain','link',10)
select dbo.fn_calc_uoc_allinone('length','chain','meter',10)
select dbo.fn_calc_uoc_allinone('length','chain','microns',10)
select dbo.fn_calc_uoc_allinone('length','chain','mile',10)
select dbo.fn_calc_uoc_allinone('length','chain','millimeters',10)
select dbo.fn_calc_uoc_allinone('length','chain','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','chain','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','chain','pica',10)
select dbo.fn_calc_uoc_allinone('length','chain','rods',10)
select dbo.fn_calc_uoc_allinone('length','chain','span',10)
select dbo.fn_calc_uoc_allinone('length','chain','yard',10)

select dbo.fn_calc_uoc_allinone('length','fathom','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','fathom','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','fathom','chain',10)
select dbo.fn_calc_uoc_allinone('length','fathom','feet',10)
select dbo.fn_calc_uoc_allinone('length','fathom','hand',10)
select dbo.fn_calc_uoc_allinone('length','fathom','inch',10)
select dbo.fn_calc_uoc_allinone('length','fathom','kilometers' ,10)
select dbo.fn_calc_uoc_allinone('length','fathom','link',10)
select dbo.fn_calc_uoc_allinone('length','fathom','meter',10)
select dbo.fn_calc_uoc_allinone('length','fathom','microns',10)
select dbo.fn_calc_uoc_allinone('length','fathom','mile',10)
select dbo.fn_calc_uoc_allinone('length','fathom','millimeters',10)
select dbo.fn_calc_uoc_allinone('length','fathom','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','fathom','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','fathom','pica',10)
select dbo.fn_calc_uoc_allinone('length','fathom','rods',10)
select dbo.fn_calc_uoc_allinone('length','fathom','span',10)
select dbo.fn_calc_uoc_allinone('length','fathom','yard',10)

select dbo.fn_calc_uoc_allinone('length','feet','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','feet','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','feet','chain',10)
select dbo.fn_calc_uoc_allinone('length','feet','fathom',10)
select dbo.fn_calc_uoc_allinone('length','feet','hand',10)
select dbo.fn_calc_uoc_allinone('length','feet','inch',10)
select dbo.fn_calc_uoc_allinone('length','feet','kilometers' ,10)
select dbo.fn_calc_uoc_allinone('length','feet','link',10)
select dbo.fn_calc_uoc_allinone('length','feet','meter',10)
select dbo.fn_calc_uoc_allinone('length','feet','microns',10)
select dbo.fn_calc_uoc_allinone('length','feet','mile',10)
select dbo.fn_calc_uoc_allinone('length','feet','millimeters',10)
select dbo.fn_calc_uoc_allinone('length','feet','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','feet','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','feet','pica',10)
select dbo.fn_calc_uoc_allinone('length','feet','rods',10)
select dbo.fn_calc_uoc_allinone('length','feet','span',10)
select dbo.fn_calc_uoc_allinone('length','feet','yard',10)

select dbo.fn_calc_uoc_allinone('length','hand','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','hand','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','hand','chain',10)
select dbo.fn_calc_uoc_allinone('length','hand','fathom',10)
select dbo.fn_calc_uoc_allinone('length','hand','feet',10)
select dbo.fn_calc_uoc_allinone('length','hand','inch',10)
select dbo.fn_calc_uoc_allinone('length','hand','kilometers' ,10)
select dbo.fn_calc_uoc_allinone('length','hand','link',10)
select dbo.fn_calc_uoc_allinone('length','hand','meter',10)
select dbo.fn_calc_uoc_allinone('length','hand','microns',10)
select dbo.fn_calc_uoc_allinone('length','hand','mile',10)
select dbo.fn_calc_uoc_allinone('length','hand','millimeters',10)
select dbo.fn_calc_uoc_allinone('length','hand','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','hand','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','hand','pica',10)
select dbo.fn_calc_uoc_allinone('length','hand','rods',10)
select dbo.fn_calc_uoc_allinone('length','hand','span',10)
select dbo.fn_calc_uoc_allinone('length','hand','yard',10)

select dbo.fn_calc_uoc_allinone('length','inch','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','inch','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','inch','chain',10)
select dbo.fn_calc_uoc_allinone('length','inch','fathom',10)
select dbo.fn_calc_uoc_allinone('length','inch','feet',10)
select dbo.fn_calc_uoc_allinone('length','inch','hand',10)
select dbo.fn_calc_uoc_allinone('length','inch','kilometers' ,10)
select dbo.fn_calc_uoc_allinone('length','inch','link',10)
select dbo.fn_calc_uoc_allinone('length','inch','meter',10)
select dbo.fn_calc_uoc_allinone('length','inch','microns',10)
select dbo.fn_calc_uoc_allinone('length','inch','mile',10)
select dbo.fn_calc_uoc_allinone('length','inch','millimeters',10)
select dbo.fn_calc_uoc_allinone('length','inch','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','inch','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','inch','pica',10)
select dbo.fn_calc_uoc_allinone('length','inch','rods',10)
select dbo.fn_calc_uoc_allinone('length','inch','span',10)
select dbo.fn_calc_uoc_allinone('length','inch','yard',10)

select dbo.fn_calc_uoc_allinone('length','kilometers','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','kilometers','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','chain',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','fathom',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','feet',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','hand',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','inch' ,10)
select dbo.fn_calc_uoc_allinone('length','kilometers','link',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','meter',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','microns',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','mile',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','millimeters',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','kilometers','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','pica',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','rods',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','span',10)
select dbo.fn_calc_uoc_allinone('length','kilometers','yard',10)

select dbo.fn_calc_uoc_allinone('length','link','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','link','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','link','chain',10)
select dbo.fn_calc_uoc_allinone('length','link','fathom',10)
select dbo.fn_calc_uoc_allinone('length','link','feet',10)
select dbo.fn_calc_uoc_allinone('length','link','hand',10)
select dbo.fn_calc_uoc_allinone('length','link','inch' ,10)
select dbo.fn_calc_uoc_allinone('length','link','kilometers',10)
select dbo.fn_calc_uoc_allinone('length','link','meter',10)
select dbo.fn_calc_uoc_allinone('length','link','microns',10)
select dbo.fn_calc_uoc_allinone('length','link','mile',10)
select dbo.fn_calc_uoc_allinone('length','link','millimeters',10)
select dbo.fn_calc_uoc_allinone('length','link','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','link','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','link','pica',10)
select dbo.fn_calc_uoc_allinone('length','link','rods',10)
select dbo.fn_calc_uoc_allinone('length','link','span',10)
select dbo.fn_calc_uoc_allinone('length','link','yard',10)

select dbo.fn_calc_uoc_allinone('length','meter','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','meter','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','meter','chain',10)
select dbo.fn_calc_uoc_allinone('length','meter','fathom',10)
select dbo.fn_calc_uoc_allinone('length','meter','feet',10)
select dbo.fn_calc_uoc_allinone('length','meter','hand',10)
select dbo.fn_calc_uoc_allinone('length','meter','inch' ,10)
select dbo.fn_calc_uoc_allinone('length','meter','kilometers',10)
select dbo.fn_calc_uoc_allinone('length','meter','link',10)
select dbo.fn_calc_uoc_allinone('length','meter','microns',10)
select dbo.fn_calc_uoc_allinone('length','meter','mile',10)
select dbo.fn_calc_uoc_allinone('length','meter','millimeters',10)
select dbo.fn_calc_uoc_allinone('length','meter','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','meter','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','meter','pica',10)
select dbo.fn_calc_uoc_allinone('length','meter','rods',10)
select dbo.fn_calc_uoc_allinone('length','meter','span',10)
select dbo.fn_calc_uoc_allinone('length','meter','yard',10)

select dbo.fn_calc_uoc_allinone('length','microns','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','microns','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','microns','chain',10)
select dbo.fn_calc_uoc_allinone('length','microns','fathom',10)
select dbo.fn_calc_uoc_allinone('length','microns','feet',10)
select dbo.fn_calc_uoc_allinone('length','microns','hand',10)
select dbo.fn_calc_uoc_allinone('length','microns','inch' ,10)
select dbo.fn_calc_uoc_allinone('length','microns','kilometers',10)
select dbo.fn_calc_uoc_allinone('length','microns','link',10)
select dbo.fn_calc_uoc_allinone('length','microns','meter',10)
select dbo.fn_calc_uoc_allinone('length','microns','mile',10)
select dbo.fn_calc_uoc_allinone('length','microns','millimeters',10)
select dbo.fn_calc_uoc_allinone('length','microns','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','microns','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','microns','pica',10)
select dbo.fn_calc_uoc_allinone('length','microns','rods',10)
select dbo.fn_calc_uoc_allinone('length','microns','span',10)
select dbo.fn_calc_uoc_allinone('length','microns','yard',10)

select dbo.fn_calc_uoc_allinone('length','mile','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','mile','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','mile','chain',10)
select dbo.fn_calc_uoc_allinone('length','mile','fathom',10)
select dbo.fn_calc_uoc_allinone('length','mile','feet',10)
select dbo.fn_calc_uoc_allinone('length','mile','hand',10)
select dbo.fn_calc_uoc_allinone('length','mile','inch' ,10)
select dbo.fn_calc_uoc_allinone('length','mile','kilometers',10)
select dbo.fn_calc_uoc_allinone('length','mile','link',10)
select dbo.fn_calc_uoc_allinone('length','mile','meter',10)
select dbo.fn_calc_uoc_allinone('length','mile','microns',10)
select dbo.fn_calc_uoc_allinone('length','mile','millimeters',10)
select dbo.fn_calc_uoc_allinone('length','mile','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','mile','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','mile','pica',10)
select dbo.fn_calc_uoc_allinone('length','mile','rods',10)
select dbo.fn_calc_uoc_allinone('length','mile','span',10)
select dbo.fn_calc_uoc_allinone('length','mile','yard',10)

select dbo.fn_calc_uoc_allinone('length','millimeters','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','millimeters','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','chain',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','fathom',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','feet',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','hand',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','inch' ,10)
select dbo.fn_calc_uoc_allinone('length','millimeters','kilometers',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','link',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','meter',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','microns',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','mile',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','nanometer' ,10)
select dbo.fn_calc_uoc_allinone('length','millimeters','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','pica',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','rods',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','span',10)
select dbo.fn_calc_uoc_allinone('length','millimeters','yard',10)

select dbo.fn_calc_uoc_allinone('length','nanometer','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','nanometer','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','chain',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','fathom',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','feet',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','hand',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','inch' ,10)
select dbo.fn_calc_uoc_allinone('length','nanometer','kilometers',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','link',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','meter',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','microns',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','mile',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','millimeters' ,10)
select dbo.fn_calc_uoc_allinone('length','nanometer','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','pica',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','rods',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','span',10)
select dbo.fn_calc_uoc_allinone('length','nanometer','yard',10)

select dbo.fn_calc_uoc_allinone('length','nautical miles','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','chain',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','fathom',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','feet',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','hand',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','inch' ,10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','kilometers',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','link',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','meter',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','microns',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','mile',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','millimeters' ,10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','nanometer',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','pica',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','rods',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','span',10)
select dbo.fn_calc_uoc_allinone('length','nautical miles','yard',10)

select dbo.fn_calc_uoc_allinone('length','pica','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','pica','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','pica','chain',10)
select dbo.fn_calc_uoc_allinone('length','pica','fathom',10)
select dbo.fn_calc_uoc_allinone('length','pica','feet',10)
select dbo.fn_calc_uoc_allinone('length','pica','hand',10)
select dbo.fn_calc_uoc_allinone('length','pica','inch' ,10)
select dbo.fn_calc_uoc_allinone('length','pica','kilometers',10)
select dbo.fn_calc_uoc_allinone('length','pica','link',10)
select dbo.fn_calc_uoc_allinone('length','pica','meter',10)
select dbo.fn_calc_uoc_allinone('length','pica','microns',10)
select dbo.fn_calc_uoc_allinone('length','pica','mile',10)
select dbo.fn_calc_uoc_allinone('length','pica','millimeters' ,10)
select dbo.fn_calc_uoc_allinone('length','pica','nanometer',10)
select dbo.fn_calc_uoc_allinone('length','pica','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','pica','rods',10)
select dbo.fn_calc_uoc_allinone('length','pica','span',10)
select dbo.fn_calc_uoc_allinone('length','pica','yard',10)

select dbo.fn_calc_uoc_allinone('length','rods','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','rods','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','rods','chain',10)
select dbo.fn_calc_uoc_allinone('length','rods','fathom',10)
select dbo.fn_calc_uoc_allinone('length','rods','feet',10)
select dbo.fn_calc_uoc_allinone('length','rods','hand',10)
select dbo.fn_calc_uoc_allinone('length','rods','inch' ,10)
select dbo.fn_calc_uoc_allinone('length','rods','kilometers',10)
select dbo.fn_calc_uoc_allinone('length','rods','link',10)
select dbo.fn_calc_uoc_allinone('length','rods','meter',10)
select dbo.fn_calc_uoc_allinone('length','rods','microns',10)
select dbo.fn_calc_uoc_allinone('length','rods','mile',10)
select dbo.fn_calc_uoc_allinone('length','rods','millimeters' ,10)
select dbo.fn_calc_uoc_allinone('length','rods','nanometer',10)
select dbo.fn_calc_uoc_allinone('length','rods','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','rods','pica',10)
select dbo.fn_calc_uoc_allinone('length','rods','span',10)
select dbo.fn_calc_uoc_allinone('length','rods','yard',10)

select dbo.fn_calc_uoc_allinone('length','span','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','span','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','span','chain',10)
select dbo.fn_calc_uoc_allinone('length','span','fathom',10)
select dbo.fn_calc_uoc_allinone('length','span','feet',10)
select dbo.fn_calc_uoc_allinone('length','span','hand',10)
select dbo.fn_calc_uoc_allinone('length','span','inch' ,10)
select dbo.fn_calc_uoc_allinone('length','span','kilometers',10)
select dbo.fn_calc_uoc_allinone('length','span','link',10)
select dbo.fn_calc_uoc_allinone('length','span','meter',10)
select dbo.fn_calc_uoc_allinone('length','span','microns',10)
select dbo.fn_calc_uoc_allinone('length','span','mile',10)
select dbo.fn_calc_uoc_allinone('length','span','millimeters' ,10)
select dbo.fn_calc_uoc_allinone('length','span','nanometer',10)
select dbo.fn_calc_uoc_allinone('length','span','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','span','pica',10)
select dbo.fn_calc_uoc_allinone('length','span','rods',10)
select dbo.fn_calc_uoc_allinone('length','span','yard',10)

select dbo.fn_calc_uoc_allinone('length','yard','angstrom' ,10)
select dbo.fn_calc_uoc_allinone('length','yard','centimeters',10)
select dbo.fn_calc_uoc_allinone('length','yard','chain',10)
select dbo.fn_calc_uoc_allinone('length','yard','fathom',10)
select dbo.fn_calc_uoc_allinone('length','yard','feet',10)
select dbo.fn_calc_uoc_allinone('length','yard','hand',10)
select dbo.fn_calc_uoc_allinone('length','yard','inch' ,10)
select dbo.fn_calc_uoc_allinone('length','yard','kilometers',10)
select dbo.fn_calc_uoc_allinone('length','yard','link',10)
select dbo.fn_calc_uoc_allinone('length','yard','meter',10)
select dbo.fn_calc_uoc_allinone('length','yard','microns',10)
select dbo.fn_calc_uoc_allinone('length','yard','mile',10)
select dbo.fn_calc_uoc_allinone('length','yard','millimeters' ,10)
select dbo.fn_calc_uoc_allinone('length','yard','nanometer',10)
select dbo.fn_calc_uoc_allinone('length','yard','nautical miles',10)
select dbo.fn_calc_uoc_allinone('length','yard','pica',10)
select dbo.fn_calc_uoc_allinone('length','yard','rods',10)
select dbo.fn_calc_uoc_allinone('length','yard','span',10)



--Mass 182 combinations
select dbo.fn_calc_uoc_allinone('mass','kilogram','gram',10)
select dbo.fn_calc_uoc_allinone('mass','kilogram','carat',10)
select dbo.fn_calc_uoc_allinone('mass','kilogram','centigram',10)
select dbo.fn_calc_uoc_allinone('mass','kilogram','decigram',10)
select dbo.fn_calc_uoc_allinone('mass','kilogram','dekagram',10)
select dbo.fn_calc_uoc_allinone('mass','kilogram','hectogram',10)
select dbo.fn_calc_uoc_allinone('mass','kilogram','milligram',10)
select dbo.fn_calc_uoc_allinone('mass','kilogram','ounce',10)
select dbo.fn_calc_uoc_allinone('mass','kilogram','pound',10)
select dbo.fn_calc_uoc_allinone('mass','kilogram','short ton',10)
select dbo.fn_calc_uoc_allinone('mass','kilogram','stone',10)
select dbo.fn_calc_uoc_allinone('mass','kilogram','tonne',10)
select dbo.fn_calc_uoc_allinone('mass','kilogram','long ton',10)

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

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

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

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

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

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

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

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

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

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

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

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

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


--Power 20 combinations
select dbo.fn_calc_uoc_allinone('power','BTU/m','FP/m',10)
select dbo.fn_calc_uoc_allinone('power','BTU/m','HP',10)
select dbo.fn_calc_uoc_allinone('power','BTU/m','KW',10)
select dbo.fn_calc_uoc_allinone('power','BTU/m','W',10)

select dbo.fn_calc_uoc_allinone('power','FP/m','BTU/m',10)
select dbo.fn_calc_uoc_allinone('power','FP/m','HP',10)
select dbo.fn_calc_uoc_allinone('power','FP/m','KW',10)
select dbo.fn_calc_uoc_allinone('power','FP/m','W',10)

select dbo.fn_calc_uoc_allinone('power','HP','BTU/m',10)
select dbo.fn_calc_uoc_allinone('power','HP','FP/m',10)
select dbo.fn_calc_uoc_allinone('power','HP','KW',10)
select dbo.fn_calc_uoc_allinone('power','HP','W',10)

select dbo.fn_calc_uoc_allinone('power','KW','BTU/m',10)
select dbo.fn_calc_uoc_allinone('power','KW','FP/m',10)
select dbo.fn_calc_uoc_allinone('power','KW','HP',10)
select dbo.fn_calc_uoc_allinone('power','KW','W',10)

select dbo.fn_calc_uoc_allinone('power','W','BTU/m',10)
select dbo.fn_calc_uoc_allinone('power','W','FP/m',10)
select dbo.fn_calc_uoc_allinone('power','W','HP',10)
select dbo.fn_calc_uoc_allinone('power','W','KW',10)



--Pressure 30 combinations
select dbo.fn_calc_uoc_allinone('pressure','A','B' ,10)
select dbo.fn_calc_uoc_allinone('pressure','A','KP',10)
select dbo.fn_calc_uoc_allinone('pressure','A','MMM',10)
select dbo.fn_calc_uoc_allinone('pressure','A','P',10)
select dbo.fn_calc_uoc_allinone('pressure','A','PSI',10)

select dbo.fn_calc_uoc_allinone('pressure','B','A' ,10)
select dbo.fn_calc_uoc_allinone('pressure','B','KP',10)
select dbo.fn_calc_uoc_allinone('pressure','B','MMM',10)
select dbo.fn_calc_uoc_allinone('pressure','B','P',10)
select dbo.fn_calc_uoc_allinone('pressure','B','PSI',10)

select dbo.fn_calc_uoc_allinone('pressure','KP','A' ,10)
select dbo.fn_calc_uoc_allinone('pressure','KP','B',10)
select dbo.fn_calc_uoc_allinone('pressure','KP','MMM',10)
select dbo.fn_calc_uoc_allinone('pressure','KP','P',10)
select dbo.fn_calc_uoc_allinone('pressure','KP','PSI',10)

select dbo.fn_calc_uoc_allinone('pressure','MMM','A' ,10)
select dbo.fn_calc_uoc_allinone('pressure','MMM','B',10)
select dbo.fn_calc_uoc_allinone('pressure','MMM','KP',10)
select dbo.fn_calc_uoc_allinone('pressure','MMM','P',10)
select dbo.fn_calc_uoc_allinone('pressure','MMM','PSI',10)

select dbo.fn_calc_uoc_allinone('pressure','P','A' ,10)
select dbo.fn_calc_uoc_allinone('pressure','P','B',10)
select dbo.fn_calc_uoc_allinone('pressure','P','KP',10)
select dbo.fn_calc_uoc_allinone('pressure','P','MMM',10)
select dbo.fn_calc_uoc_allinone('pressure','P','PSI',10)

select dbo.fn_calc_uoc_allinone('pressure','PSI','A' ,10)
select dbo.fn_calc_uoc_allinone('pressure','PSI','B',10)
select dbo.fn_calc_uoc_allinone('pressure','PSI','KP',10)
select dbo.fn_calc_uoc_allinone('pressure','PSI','MMM',10)
select dbo.fn_calc_uoc_allinone('pressure','PSI','P',10)



--Temperature 6 combinations
select dbo.fn_calc_uoc_allinone('temperature','DC','DF',10)
select dbo.fn_calc_uoc_allinone('temperature','DC','K',10)

select dbo.fn_calc_uoc_allinone('temperature','DF','DC',10)
select dbo.fn_calc_uoc_allinone('temperature','DF','K',10)

select dbo.fn_calc_uoc_allinone('temperature','K','DC',10)
select dbo.fn_calc_uoc_allinone('temperature','K','DF',10)


--Time 42 combinations
select dbo.fn_calc_uoc_allinone('time','day','hour',10)
select dbo.fn_calc_uoc_allinone('time','day','microsecond',10)
select dbo.fn_calc_uoc_allinone('time','day','millisecond',10)
select dbo.fn_calc_uoc_allinone('time','day','minute',10)
select dbo.fn_calc_uoc_allinone('time','day','second',10)
select dbo.fn_calc_uoc_allinone('time','day','week',10)

select dbo.fn_calc_uoc_allinone('time','hour','day',10)
select dbo.fn_calc_uoc_allinone('time','hour','microsecond',10)
select dbo.fn_calc_uoc_allinone('time','hour','millisecond',10)
select dbo.fn_calc_uoc_allinone('time','hour','minute',10)
select dbo.fn_calc_uoc_allinone('time','hour','second',10)
select dbo.fn_calc_uoc_allinone('time','hour','week',10)

select dbo.fn_calc_uoc_allinone('time','microsecond','day',10)
select dbo.fn_calc_uoc_allinone('time','microsecond','hour',10)
select dbo.fn_calc_uoc_allinone('time','microsecond','millisecond',10)
select dbo.fn_calc_uoc_allinone('time','microsecond','minute',10)
select dbo.fn_calc_uoc_allinone('time','microsecond','second',10)
select dbo.fn_calc_uoc_allinone('time','microsecond','week',10)

select dbo.fn_calc_uoc_allinone('time','millisecond','day',10)
select dbo.fn_calc_uoc_allinone('time','millisecond','hour',10)
select dbo.fn_calc_uoc_allinone('time','millisecond','microsecond',10)
select dbo.fn_calc_uoc_allinone('time','millisecond','minute',10)
select dbo.fn_calc_uoc_allinone('time','millisecond','second',10)
select dbo.fn_calc_uoc_allinone('time','millisecond','week',10)

select dbo.fn_calc_uoc_allinone('time','minute','day',10)
select dbo.fn_calc_uoc_allinone('time','minute','hour',10)
select dbo.fn_calc_uoc_allinone('time','minute','microsecond',10)
select dbo.fn_calc_uoc_allinone('time','minute','millisecond',10)
select dbo.fn_calc_uoc_allinone('time','minute','second',10)
select dbo.fn_calc_uoc_allinone('time','minute','week',10)

select dbo.fn_calc_uoc_allinone('time','second','day',10)
select dbo.fn_calc_uoc_allinone('time','second','hour',10)
select dbo.fn_calc_uoc_allinone('time','second','microsecond',10)
select dbo.fn_calc_uoc_allinone('time','second','millisecond',10)
select dbo.fn_calc_uoc_allinone('time','second','minute',10)
select dbo.fn_calc_uoc_allinone('time','second','week',10)

select dbo.fn_calc_uoc_allinone('time','week','day',10)
select dbo.fn_calc_uoc_allinone('time','week','hour',10)
select dbo.fn_calc_uoc_allinone('time','week','microsecond',10)
select dbo.fn_calc_uoc_allinone('time','week','millisecond',10)
select dbo.fn_calc_uoc_allinone('time','week','minute',10)
select dbo.fn_calc_uoc_allinone('time','week','second',10)



--Velocity 42 combinations
select dbo.fn_calc_uoc_allinone('velocity','cmps','fps' ,10)
select dbo.fn_calc_uoc_allinone('velocity','cmps','kmph',10)
select dbo.fn_calc_uoc_allinone('velocity','cmps','knots',10)
select dbo.fn_calc_uoc_allinone('velocity','cmps','mach',10)
select dbo.fn_calc_uoc_allinone('velocity','cmps','mtps',10)
select dbo.fn_calc_uoc_allinone('velocity','cmps','mph',10)

select dbo.fn_calc_uoc_allinone('velocity','fps','cmps' ,10)
select dbo.fn_calc_uoc_allinone('velocity','fps','kmph',10)
select dbo.fn_calc_uoc_allinone('velocity','fps','knots',10)
select dbo.fn_calc_uoc_allinone('velocity','fps','mach',10)
select dbo.fn_calc_uoc_allinone('velocity','fps','mtps',10)
select dbo.fn_calc_uoc_allinone('velocity','fps','mph',10)

select dbo.fn_calc_uoc_allinone('velocity','kmph','cmps' ,10)
select dbo.fn_calc_uoc_allinone('velocity','kmph','fps',10)
select dbo.fn_calc_uoc_allinone('velocity','kmph','knots',10)
select dbo.fn_calc_uoc_allinone('velocity','kmph','mach',10)
select dbo.fn_calc_uoc_allinone('velocity','kmph','mtps',10)
select dbo.fn_calc_uoc_allinone('velocity','kmph','mph',10)

select dbo.fn_calc_uoc_allinone('velocity','knots','cmps' ,10)
select dbo.fn_calc_uoc_allinone('velocity','knots','fps',10)
select dbo.fn_calc_uoc_allinone('velocity','knots','kmph',10)
select dbo.fn_calc_uoc_allinone('velocity','knots','mach',10)
select dbo.fn_calc_uoc_allinone('velocity','knots','mtps',10)
select dbo.fn_calc_uoc_allinone('velocity','knots','mph',10)

select dbo.fn_calc_uoc_allinone('velocity','mach','cmps' ,10)
select dbo.fn_calc_uoc_allinone('velocity','mach','fps',10)
select dbo.fn_calc_uoc_allinone('velocity','mach','kmph',10)
select dbo.fn_calc_uoc_allinone('velocity','mach','knots',10)
select dbo.fn_calc_uoc_allinone('velocity','mach','mtps',10)
select dbo.fn_calc_uoc_allinone('velocity','mach','mph',10)

select dbo.fn_calc_uoc_allinone('velocity','mtps','cmps' ,10)
select dbo.fn_calc_uoc_allinone('velocity','mtps','fps',10)
select dbo.fn_calc_uoc_allinone('velocity','mtps','kmph',10)
select dbo.fn_calc_uoc_allinone('velocity','mtps','knots',10)
select dbo.fn_calc_uoc_allinone('velocity','mtps','mach',10)
select dbo.fn_calc_uoc_allinone('velocity','mtps','mph',10)

select dbo.fn_calc_uoc_allinone('velocity','mph','cmps' ,10)
select dbo.fn_calc_uoc_allinone('velocity','mph','fps',10)
select dbo.fn_calc_uoc_allinone('velocity','mph','kmph',10)
select dbo.fn_calc_uoc_allinone('velocity','mph','knots',10)
select dbo.fn_calc_uoc_allinone('velocity','mph','mach',10)
select dbo.fn_calc_uoc_allinone('velocity','mph','mtps',10)


--Volume 182 combinations
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','cubic feet',10)
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','cubic inch',10)
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','cubic meter',10)
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','cubic yard',10)
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','fluid ounce - UK',10)
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','fluid ounce - US',10)
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','gallon - UK',10)
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','gallon - US',10)
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','liter',10)
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','pint - UK',10)
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','pint - US',10)
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','quart - UK',10)
select dbo.fn_calc_uoc_allinone('volume','cubic centimeter','quart - US',10)

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

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

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

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

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

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

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

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

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

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

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

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

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