USP_INDIVIDUAL_EDITLOAD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@LASTNAME	nvarchar(100)	INOUT
@FIRSTNAME	nvarchar(50)	INOUT
@MIDDLENAME	nvarchar(50)	INOUT
@MAIDENNAME	nvarchar(100)	INOUT
@NICKNAME	nvarchar(50)	INOUT
@TITLECODEID	uniqueidentifier	INOUT
@SUFFIXCODEID	uniqueidentifier	INOUT
@GENDERCODE	tinyint	INOUT
@BIRTHDATE	UDT_FUZZYDATE	INOUT
@AGE	int	INOUT
@GIVESANONYMOUSLY	bit	INOUT
@PICTURE	varbinary	INOUT
@PICTURETHUMBNAIL	varbinary	INOUT
@PICTURECHANGED	bit	INOUT
@WEBADDRESS	UDT_WEBADDRESS	INOUT
@TSLONG	bigint	INOUT
@MARITALSTATUSCODEID	uniqueidentifier	INOUT
@TITLE2CODEID	uniqueidentifier	INOUT
@SUFFIX2CODEID	uniqueidentifier	INOUT
@ISDECEASED	bit	INOUT
@GENDERCODEID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_INDIVIDUAL_EDITLOAD (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @LASTNAME nvarchar(100) = null output,
    @FIRSTNAME nvarchar(50) = null output,
    @MIDDLENAME nvarchar(50) = null output,
      @MAIDENNAME nvarchar(100) = null output,
      @NICKNAME nvarchar(50) = null output,
    @TITLECODEID uniqueidentifier = null output,
    @SUFFIXCODEID uniqueidentifier = null output,
    @GENDERCODE tinyint = null output,
    @BIRTHDATE dbo.UDT_FUZZYDATE = null output,
    @AGE int = null output,
    @GIVESANONYMOUSLY bit = null output,
    @PICTURE varbinary(max) = null output,
      @PICTURETHUMBNAIL varbinary(max) = null output,
      @PICTURECHANGED bit = null output,
      @WEBADDRESS dbo.UDT_WEBADDRESS = null output,
    @TSLONG bigint = 0 output,
      @MARITALSTATUSCODEID as uniqueidentifier = null output,
      @TITLE2CODEID uniqueidentifier = null output,
    @SUFFIX2CODEID uniqueidentifier = null output,
    @ISDECEASED bit = null output,
    @GENDERCODEID uniqueidentifier = null output
) as
    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;

    select
        @DATALOADED = 1,
        @ID = CONSTITUENT.ID,
        @LASTNAME = CONSTITUENT.KEYNAME,
        @FIRSTNAME = CONSTITUENT.FIRSTNAME,
        @MIDDLENAME = CONSTITUENT.MIDDLENAME,
            @MAIDENNAME = CONSTITUENT.MAIDENNAME,
            @NICKNAME = CONSTITUENT.NICKNAME,
        @TITLECODEID = CONSTITUENT.TITLECODEID,
        @SUFFIXCODEID = CONSTITUENT.SUFFIXCODEID,
        @GENDERCODE = CONSTITUENT.GENDERCODE,
        @BIRTHDATE = CONSTITUENT.BIRTHDATE,
        @AGE = case when DECEASEDCONSTITUENT.ID is null then CONSTITUENT.AGE else null end,
        @GIVESANONYMOUSLY = CONSTITUENT.GIVESANONYMOUSLY,
        @PICTURE = CONSTITUENT.PICTURE,
        @PICTURETHUMBNAIL = CONSTITUENT.PICTURETHUMBNAIL,
            @WEBADDRESS = CONSTITUENT.WEBADDRESS,
        @TSLONG = CONSTITUENT.TSLONG,
            @MARITALSTATUSCODEID = CONSTITUENT.MARITALSTATUSCODEID,
            @TITLE2CODEID = CONSTITUENT.TITLE2CODEID,
        @SUFFIX2CODEID = CONSTITUENT.SUFFIX2CODEID,
        @ISDECEASED = case when DECEASEDCONSTITUENT.ID is null then 0 else 1 end,
        @GENDERCODEID = GENDERCODEID
    from
        dbo.CONSTITUENT
        left join dbo.DECEASEDCONSTITUENT on CONSTITUENT.ID = DECEASEDCONSTITUENT.ID
    where
        CONSTITUENT.ID = @ID and
        CONSTITUENT.ISORGANIZATION = 0;

    return 0;