• First off, it is good practice to use meaningful names for your parameters so when you revisit your code next year or someone else does they know what is expected.

    That said, put parentheses around your function result:

    Set @desiredValue=(SELECT @ScalarFunctionResult(@Param1,@Param2))