UFN_CURRENCYEXCHANGERATE_GETTRANSLATION

                CREATE function dbo.UFN_CURRENCYEXCHANGERATE_GETTRANSLATION
                (
                    @ID uniqueidentifier
                ) 
                returns nvarchar(120)
                with execute as caller
                as
                begin
                    declare @DESCRIPTION nvarchar(120);

                    if @ID = '00000000-0000-0000-0000-000000000001'
                        select @DESCRIPTION = 'Spot rate'
                    else
                    begin
                        select
                            @DESCRIPTION = 
                                case
                                    when CURRENCYEXCHANGERATE.SOURCECODEID is null
                                        then convert(nvarchar,CURRENCYEXCHANGERATE.ASOFDATE)
                                    else 
                                        CURRENCYEXCHANGERATESOURCECODE.DESCRIPTION + ' (' + convert(nvarchar,convert(datetime,CURRENCYEXCHANGERATE.ASOFDATE)) + ' ' + TIMEZONEENTRY.NAME + ')'
                                end
                        from
                            dbo.CURRENCYEXCHANGERATE
                            left join dbo.CURRENCYEXCHANGERATESOURCECODE on CURRENCYEXCHANGERATESOURCECODE.ID = CURRENCYEXCHANGERATE.SOURCECODEID
                            left join dbo.TIMEZONEENTRY on TIMEZONEENTRY.ID = CURRENCYEXCHANGERATE.TIMEZONEENTRYID
                        where
                            CURRENCYEXCHANGERATE.ID = @ID;
                    end

                    return @DESCRIPTION;
                end