UFN_SITEID_MAPFROM_EVENTMANAGEMENTTEMPLATE

Maps an event management template id to a site id.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTMANAGEMENTTEMPLATEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_EVENTMANAGEMENTTEMPLATE  
            (  
                @EVENTMANAGEMENTTEMPLATEID uniqueidentifier  
            )   
            returns table
            as  
            return
                select EVENTMANAGEMENTTEMPLATESITE.SITEID
                from dbo.EVENTMANAGEMENTTEMPLATE
                left outer join dbo.EVENTMANAGEMENTTEMPLATESITE on EVENTMANAGEMENTTEMPLATESITE.EVENTMANAGEMENTTEMPLATEID = EVENTMANAGEMENTTEMPLATE.ID
                where EVENTMANAGEMENTTEMPLATE.ID = @EVENTMANAGEMENTTEMPLATEID;