UFN_BUILDNAMEFORMAT_INTERNAL
Return
| Return Type |
|---|
| nvarchar(700) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @NAMEFORMATFUNCTIONID | uniqueidentifier | IN | |
| @CONSTITUENTID | uniqueidentifier | IN | |
| @LASTNAME | nvarchar(100) | IN | |
| @FIRSTNAME | nvarchar(50) | IN | |
| @MIDDLENAME | nvarchar(50) | IN | |
| @TITLE | nvarchar(100) | IN | |
| @SUFFIX | nvarchar(100) | IN | |
| @SPOUSELASTNAME | nvarchar(100) | IN | |
| @SPOUSEFIRSTNAME | nvarchar(50) | IN | |
| @SPOUSEMIDDLENAME | nvarchar(50) | IN | |
| @SPOUSETITLE | nvarchar(100) | IN | |
| @SPOUSESUFFIX | nvarchar(100) | IN | |
| @EXCLUDESPOUSEINFO | bit | IN |
Definition
Copy
CREATE function dbo.UFN_BUILDNAMEFORMAT_INTERNAL(@NAMEFORMATFUNCTIONID uniqueidentifier,@CONSTITUENTID uniqueidentifier,
@LASTNAME nvarchar(100),@FIRSTNAME nvarchar(50),@MIDDLENAME nvarchar(50),
@TITLE nvarchar(100),@SUFFIX nvarchar(100),@SPOUSELASTNAME nvarchar(100),
@SPOUSEFIRSTNAME nvarchar(50),@SPOUSEMIDDLENAME nvarchar(50),
@SPOUSETITLE nvarchar(100),@SPOUSESUFFIX nvarchar(100), @EXCLUDESPOUSEINFO bit = 0)
returns nvarchar(700)
with execute as caller
/*This code was auto-generated by calling dbo.USP_CREATEORUPDATE_BUILDNAMEFORMAT on Jan 27 2010 7:25PM. */
as
begin
/* format the name(s) based on name format */
/* remove spouse fields if need be */
if @EXCLUDESPOUSEINFO = 1 begin
set @SPOUSEFIRSTNAME = '';
set @SPOUSEMIDDLENAME = '';
set @SPOUSELASTNAME = '';
set @SPOUSETITLE = '';
set @SPOUSESUFFIX = '';
end
IF @NAMEFORMATFUNCTIONID = 'EC34BBF2-D21D-4D28-B041-AFFBB3A84C16'
return dbo.UFN_NAMEFORMAT_01(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'CBDC4F04-FE99-43F8-9FD7-89B67CAA440A'
return dbo.UFN_NAMEFORMATFUNCTION_FULLYQUALIFIED(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'CFBD2C66-8AC9-4C1F-9325-7A14F06ABC0A'
return dbo.UFN_NAMEFORMATFUNCTION_SIMPLE(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '30CF3DE1-A26C-456C-AD8F-D5816A96C42D'
return dbo.UFN_NAMEFORMAT_02(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '20722B35-F885-4C5C-8B77-DA05FE4543DF'
return dbo.UFN_NAMEFORMAT_03(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'BD539224-B531-4503-BFD1-E382B1C34EB8'
return dbo.UFN_NAMEFORMAT_04(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '94F55EDE-704C-4F4C-8B21-06B1738215B6'
return dbo.UFN_NAMEFORMAT_05(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'B65F12B8-8EF0-4701-AE08-2FE85CED9A9A'
return dbo.UFN_NAMEFORMAT_06(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'D3CEAF66-7768-420E-8D2E-7429C97EC64D'
return dbo.UFN_NAMEFORMAT_07(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'A6C1B607-DDC0-4E74-A538-76C67DEC8DE7'
return dbo.UFN_NAMEFORMAT_08(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '79090CEC-3A2F-4A09-A781-40A18A345F94'
return dbo.UFN_NAMEFORMAT_09(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '3D7449CE-BA34-4BB8-B2F2-F0602265EFE4'
return dbo.UFN_NAMEFORMAT_10(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '9442BF28-F8F4-456E-9D98-D9B7409BB03F'
return dbo.UFN_NAMEFORMAT_11(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '546C5BF0-BBC1-40E8-A865-F29BE8DEE2AE'
return dbo.UFN_NAMEFORMAT_12(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'B7EF6BC5-D3B3-4681-9F81-294FFDA60FFA'
return dbo.UFN_NAMEFORMAT_13(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '4AE9B681-0F8D-4C64-82CB-BB4BE44B5560'
return dbo.UFN_NAMEFORMAT_14(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '16806D49-65E2-4AE5-A582-A3204521800F'
return dbo.UFN_NAMEFORMAT_15(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '3429F509-7AB1-452B-8793-D41C427EF648'
return dbo.UFN_NAMEFORMAT_16(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'E4AA29F3-AB6D-4FBC-AF6A-C759B2132A0E'
return dbo.UFN_NAMEFORMAT_17(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'A722B46F-EC8A-4E1B-A068-49D2AB4DA757'
return dbo.UFN_NAMEFORMAT_18(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'DFF725D7-AD2C-4308-BB72-B697402F88B3'
return dbo.UFN_NAMEFORMAT_19(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'B5AC9818-D155-4964-85B6-FFB3B37A12B4'
return dbo.UFN_NAMEFORMAT_20(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'F780AFD0-0E09-4F70-897C-657B549177CC'
return dbo.UFN_NAMEFORMAT_21(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '4D5E3FB6-4CD5-43C4-AC33-2674AAE9E4B1'
return dbo.UFN_NAMEFORMAT_22(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'FB7A34D5-D71D-4653-B68E-571F399E87C5'
return dbo.UFN_NAMEFORMAT_23(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'F793C849-BA97-43B7-B9D0-6CE5F1438FFD'
return dbo.UFN_NAMEFORMAT_24(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'DD7DED20-0CE0-406E-AC7E-5C1A41C02F83'
return dbo.UFN_NAMEFORMAT_25(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '0E28FD97-EC86-43A6-BFC7-ED7DDBD2B538'
return dbo.UFN_NAMEFORMAT_26(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '788B6795-2EF7-45D1-8364-74964CABB16E'
return dbo.UFN_NAMEFORMAT_27(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '90146ACD-8AB0-491D-B35D-33F50136DBD0'
return dbo.UFN_NAMEFORMAT_28(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '17FA9167-ECA7-4278-8453-F0D3A6886EBC'
return dbo.UFN_NAMEFORMAT_29(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '6073C76C-8833-4E1E-A035-377043DF0532'
return dbo.UFN_NAMEFORMAT_30(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '05E0F9C2-9A75-43AD-A4B8-0AE60D7EAFF9'
return dbo.UFN_NAMEFORMAT_31(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'EB2E51BA-68D7-4F69-B301-D4135A39E66F'
return dbo.UFN_NAMEFORMAT_32(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '87500C2D-80AE-408C-AD85-78A57A33CF73'
return dbo.UFN_NAMEFORMAT_33(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = 'A12ACB01-4225-4047-ADA8-728BF9A4DCC2'
return dbo.UFN_NAMEFORMAT_34(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
IF @NAMEFORMATFUNCTIONID = '3CFD642B-7400-4D0F-B31E-584E26A61141'
return dbo.UFN_NAMEFORMAT_35(@CONSTITUENTID,@LASTNAME,@FIRSTNAME,@MIDDLENAME,@TITLE,@SUFFIX,@SPOUSELASTNAME,@SPOUSEFIRSTNAME,@SPOUSEMIDDLENAME,@SPOUSETITLE,@SPOUSESUFFIX)
return ''
end