UFN_CONSTITUENT_GETNAMEFORMATS
This SQL function returns all name formats for a given constituent.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_CONSTITUENT_GETNAMEFORMATS(@CONSTITUENTID uniqueidentifier)
returns table
as
return
(
select
[ID],
[NAMEFORMATTYPECODEID],
[NAMEFORMATFUNCTIONID],
[PRIMARYADDRESSEE],
[PRIMARYSALUTATION],
[SEQUENCE],
[SITEID]
from
dbo.NAMEFORMAT
where
CONSTITUENTID = @CONSTITUENTID and
NAMEFORMATFUNCTIONID is not null
)