UFN_CONSTITUENT_RESTRICTIONOPTIONS

            CREATE function dbo.UFN_CONSTITUENT_RESTRICTIONOPTIONS
            (
                @CONSTITUENTID uniqueidentifier
            )
            returns table
            as 
                return
                (
                    select
                        CONSTITUENTRESTRICTIONOPTION.ID [ID],
                        EVENTRESTRICTIONTYPE.ID [EVENTRESTRICTIONTYPEID],
                        EVENTRESTRICTIONOPTION.ID [EVENTRESTRICTIONOPTIONID],
                        EVENTRESTRICTIONTYPE.NAME [EVENTRESTRICTIONTYPENAME],
                        EVENTRESTRICTIONOPTION.NAME [EVENTRESTRICTIONOPTIONNAME]
                    from dbo.CONSTITUENTRESTRICTIONOPTION
                    inner join dbo.EVENTRESTRICTIONOPTION
                        on EVENTRESTRICTIONOPTION.ID = CONSTITUENTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID
                    inner join dbo.EVENTRESTRICTIONTYPE
                        on EVENTRESTRICTIONTYPE.ID = EVENTRESTRICTIONOPTION.EVENTRESTRICTIONTYPEID
                    where CONSTITUENTID = @CONSTITUENTID
                )