USP_DATAFORMTEMPLATE_EDIT_PRINTMEMBERSHIPCARDSPREPROCESS
USP_DATAFORMTEMPLATE_EDIT_PRINTMEMBERSHIPCARDSPREPROCESS
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter indicating the ID of the record being edited. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @MEMBERSHIPCARDFORMAT | nvarchar(255) | IN | Card format to use |
| @CREATEOUTPUTIDSET | bit | IN | Create constituent selection from results |
| @OUTPUTIDSETNAME | nvarchar(100) | IN | Selection name |
| @OVERWRITEOUTPUTIDSET | bit | IN | Overwrite existing selection |
Definition
Copy
CREATE procedure USP_DATAFORMTEMPLATE_EDIT_PRINTMEMBERSHIPCARDSPREPROCESS
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@MEMBERSHIPCARDFORMAT nvarchar(255),
@CREATEOUTPUTIDSET bit,
@OUTPUTIDSETNAME nvarchar(100),
@OVERWRITEOUTPUTIDSET bit
)
as
set nocount on;
declare @LETTERTEMPLATEID uniqueidentifier;
exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PRINTMEMBERSHIPCARDSPREPROCESS
@ID = @ID,
@LETTERTEMPLATEID = @LETTERTEMPLATEID output
exec dbo.USP_DATAFORMTEMPLATE_EDIT_PRINTMEMBERSHIPCARDSPREPROCESS_2
@ID,
@CHANGEAGENTID,
@MEMBERSHIPCARDFORMAT,
@CREATEOUTPUTIDSET,
@OUTPUTIDSETNAME,
@OVERWRITEOUTPUTIDSET,
@LETTERTEMPLATEID
return 0;