UFN_TRANSLATIONFUNCTION_EVENTAUCTION

                CREATE function dbo.UFN_TRANSLATIONFUNCTION_EVENTAUCTION
                (
                    @ID uniqueidentifier
                ) returns nvarchar(50) 
                as
                begin
                    declare @NAME nvarchar(100);
                    select @NAME = NAME 
                        from dbo.EVENTAUCTION
                        inner join dbo.EVENT
                            on EVENT.ID = EVENTAUCTION.ID
                        where EVENTAUCTION.ID = @ID;
                    return @NAME;
                end