USP_DATALIST_EVENTINVITATIONS

Displays the invitations used for a specific event.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_EVENTINVITATIONS
                (
                    @EVENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select
                        INVITATION.ID,
                        INVITATION.EVENTID,
                        INVITATION.NAME,
                        INVITATION.MAILDATE,                                        
                        INVITATION.DESCRIPTION
                    from
                        dbo.INVITATION
                    where
                        INVITATION.EVENTID = @EVENTID
                    order by
                        INVITATION.DATECHANGED;