USP_DATAFORMTEMPLATE_ADD_INVITATIONRESEND_PRELOAD

Parameters

Parameter	Parameter Type	Mode
@INVITATIONPARAMETERSETIDEVENTID	char(72)	IN
@NAME	nvarchar(100)	INOUT
@EVENTNAME	nvarchar(100)	INOUT
@BUSINESSPROCESSVIEWID	uniqueidentifier	INOUT
@RESENDFORMID	uniqueidentifier	INOUT
@INVITEESEARCHLISTID	uniqueidentifier	INOUT
@INVITEEDETAILVIEWID	uniqueidentifier	INOUT

Definition

Copy



                    create procedure dbo.USP_DATAFORMTEMPLATE_ADD_INVITATIONRESEND_PRELOAD
                    (
                        @INVITATIONPARAMETERSETIDEVENTID char(72),
                        @NAME nvarchar(100) = null output,
                        @EVENTNAME nvarchar(100) = null output,
                        @BUSINESSPROCESSVIEWID uniqueidentifier = null output,
                        @RESENDFORMID uniqueidentifier = null output,
                        @INVITEESEARCHLISTID uniqueidentifier = null output,
                        @INVITEEDETAILVIEWID uniqueidentifier = null output
                    )
                    as
                        set nocount on;

                        select
                            @NAME = NAME,
                            @BUSINESSPROCESSVIEWID = BUSINESSPROCESSVIEWID,
                            @EVENTNAME = dbo.UFN_EVENT_GETNAME(right(@INVITATIONPARAMETERSETIDEVENTID, 36)),
                            @RESENDFORMID = 'A0A6DEB4-03B3-47A4-86AD-6C51CF37A9FF',
                            @INVITEESEARCHLISTID = 'E4D7BDE7-51C2-4883-831B-CEF83F96E974',
                            @INVITEEDETAILVIEWID = '9D4F08ED-DA59-4CBE-90BB-4B7CCE170B30'
                        from
                            dbo.INVITATION
                        where
                            ID = left(@INVITATIONPARAMETERSETIDEVENTID, 36);

                        return 0;