UFN_EVENTMANAGEMENTTEMPLATE_GETSITES

Returns all sites for a given event management template.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTMANAGEMENTTEMPLATEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EVENTMANAGEMENTTEMPLATE_GETSITES
            (
                @EVENTMANAGEMENTTEMPLATEID uniqueidentifier
            )
            returns table
            as
            return
            (
                select 
                    ID, SITEID
                from 
                    dbo.EVENTMANAGEMENTTEMPLATESITE
                where 
                    EVENTMANAGEMENTTEMPLATEID = @EVENTMANAGEMENTTEMPLATEID
            )