UFN_CURRENCYSET_GETAPPUSERCURRENCYSET

Returns the currency set of the given application user.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@APPUSERID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CURRENCYSET_GETAPPUSERCURRENCYSET
            (
                @APPUSERID uniqueidentifier
            )
            returns uniqueidentifier
            with execute as caller
            as
            begin
                return coalesce
                (
                    (select CURRENCYSETID from dbo.APPUSERCURRENCYSET where APPUSERID = @APPUSERID), 
                    dbo.UFN_CURRENCYSET_GETAPPUSERDEFAULTCURRENCYSET()
                );
            end