if anyone needs the solution here is what I came up with.......:w00t:

/*

Select dbo.GetUOMMultiplier(

29,--@requiredUOMID INT,

26

)

Select *

FROM Setup.UOM

*/

--=========================================================

ALTER FUNCTION GetUOMMultiplier(

@requiredUOMID INT,

@currentUOMID INt

)

RETURNS DECIMAL(19,2)

AS

BEGIN

IF(@requiredUOMID!=@currentUOMID)

BEGIN

DECLARE @parentID INT

SET @parentID =0

DECLARE @currMultiplier DECIMAL(16,2)

SET @currMultiplier =1;

SELECT @currMultiplier...