UFN_INTERACTION_PARTICIPANTS

            CREATE function dbo.UFN_INTERACTION_PARTICIPANTS(@INTERACTIONID uniqueidentifier)
            returns table
            as return
                select 
                    IP.ID, 
                    IP.CONSTITUENTID,
                    C.KEYNAME,
                    C.FIRSTNAME
                from dbo.INTERACTIONPARTICIPANT IP
                inner join dbo.CONSTITUENT C on IP.CONSTITUENTID = C.ID
                where
                    INTERACTIONID = @INTERACTIONID;