UFN_EVENTPREFERENCEGROUP_GETNAMEANDEVENTNAME

                create function dbo.UFN_EVENTPREFERENCEGROUP_GETNAMEANDEVENTNAME
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(203) with execute as caller
                as
                begin
                    declare @NAME nvarchar(203);

                    select
                        @NAME = NAME + N' (' + dbo.UFN_EVENT_GETNAME(EVENTID) + N')'
                    from
                        dbo.EVENTPREFERENCEGROUP
                    where
                        ID = @ID;

                    return @NAME;
                end