UFN_SITEID_MAPFROM_REGISTRANTID

Maps a REGISTRANTID to a SiteID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REGISTRANTID	uniqueidentifier	IN

Definition

Copy



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