UFN_AMPROIMPORT_EVENTPRICE_TRANSLATION

                CREATE function dbo.UFN_AMPROIMPORT_EVENTPRICE_TRANSLATION(@ID uniqueidentifier)
                returns nvarchar(255)
                as
                begin
                    declare @R nvarchar(255);

                    select @R = EVENTPRICE.NAME + ' - ' + convert(nvarchar(20), EVENTPRICE.AMOUNT) + ' ' + dbo.UFN_CURRENCY_GETISO(EVENT.BASECURRENCYID)
                    from dbo.EVENTPRICE 
                    inner join dbo.EVENT on EVENT.ID = EVENTPRICE.EVENTID
                    where EVENTPRICE.ID = @ID;

                    return @R;
                end