USP_SIMPLEDATALIST_EVENT_EVENTINVITATIONS

A simple data list of invitations for a specific event.

Parameters

Parameter	Parameter Type	Mode	Description
@DESTINATIONINVITATIONID	uniqueidentifier	IN
@SOURCEEVENTID	uniqueidentifier	IN

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_EVENT_EVENTINVITATIONS
                (
                    @DESTINATIONINVITATIONID uniqueidentifier = null,
                    @SOURCEEVENTID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select
                        INVITATION.ID as VALUE,
                        INVITATION.NAME as LABEL 
                    from 
                        dbo.INVITATION
                    where 
                        INVITATION.EVENTID = @SOURCEEVENTID and 
                        INVITATION.ID <> @DESTINATIONINVITATIONID
                    order by 
                        INVITATION.NAME;