UFN_SITEID_MAPFROM_REGISTRANTREGISTRATIONID

            create function dbo.UFN_SITEID_MAPFROM_REGISTRANTREGISTRATIONID  
            (  
            @REGISTRANTREGISTRATIONID uniqueidentifier  
            )   
            returns table
            as  
            return  
                select EVENTSITE.SITEID   
                from dbo.REGISTRANTREGISTRATION
                left outer join dbo.REGISTRANT on REGISTRANT.ID = REGISTRANTREGISTRATION.REGISTRANTID  
                left outer join dbo.EVENTSITE on EVENTSITE.EVENTID = REGISTRANT.EVENTID  
                where REGISTRANTREGISTRATION.ID = @REGISTRANTREGISTRATIONID;