USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTPROFILEINDIVIDUALINFOTILE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @DATALOADED | bit | INOUT | |
| @PICTURE | varbinary | INOUT | |
| @TITLE | nvarchar(100) | INOUT | |
| @FIRSTNAME | nvarchar(50) | INOUT | |
| @MIDDLENAME | nvarchar(50) | INOUT | |
| @KEYNAME | nvarchar(100) | INOUT | |
| @SUFFIX | nvarchar(100) | INOUT | |
| @NICKNAME | nvarchar(50) | INOUT | |
| @MAIDENNAME | nvarchar(100) | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTPROFILEINDIVIDUALINFOTILE
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@PICTURE varbinary(max) = null output,
@TITLE nvarchar(100) = null output,
@FIRSTNAME nvarchar(50) = null output,
@MIDDLENAME nvarchar(50) = null output,
@KEYNAME nvarchar(100) = null output,
@SUFFIX nvarchar(100) = null output,
@NICKNAME nvarchar(50) = null output,
@MAIDENNAME nvarchar(100) = null output
)
as
select
@DATALOADED = 1,
@PICTURE = CONSTITUENT.PICTURETHUMBNAIL,
@TITLE = TITLECODE.DESCRIPTION,
@FIRSTNAME = CONSTITUENT.FIRSTNAME,
@MIDDLENAME = CONSTITUENT.MIDDLENAME,
@KEYNAME = CONSTITUENT.KEYNAME,
@SUFFIX = SUFFIXCODE.DESCRIPTION,
@NICKNAME = CONSTITUENT.NICKNAME,
@MAIDENNAME = CONSTITUENT.MAIDENNAME
from dbo.CONSTITUENT
left join dbo.TITLECODE on CONSTITUENT.TITLECODEID = TITLECODE.ID
left join dbo.SUFFIXCODE on CONSTITUENT.SUFFIXCODEID = SUFFIXCODE.ID
where CONSTITUENT.ID = @ID;