USP_DATAFORMTEMPLATE_EDITLOAD_BIOGRAPHICALDEMOGRAPHIC2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@SOURCE	nvarchar(100)	INOUT
@FIRSTNAME	nvarchar(100)	INOUT
@MIDDLENAME	nvarchar(100)	INOUT
@LASTNAME	nvarchar(100)	INOUT
@SUFFIXCODEID	uniqueidentifier	INOUT
@TITLECODEID	uniqueidentifier	INOUT
@BIRTHDATE	UDT_FUZZYDATE	INOUT
@AGE	int	INOUT
@MARITALSTATUSCODEID	uniqueidentifier	INOUT
@OCCUPATION	nvarchar(100)	INOUT
@CNOTES	nvarchar(1024)	INOUT
@HOUSEHOLDMOSAIC	nvarchar(100)	INOUT
@HOUSEHOLDINCOMECODEID	uniqueidentifier	INOUT
@DISCRETIONARYSPENDING	money	INOUT
@HHMEMBERS	xml	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BIOGRAPHICALDEMOGRAPHIC2
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
      @SOURCE nvarchar(100) = null output,
      @FIRSTNAME nvarchar(100) = null output,
    @MIDDLENAME nvarchar(100) = null output,
    @LASTNAME nvarchar(100) = null output,
      @SUFFIXCODEID uniqueidentifier = null output,
    @TITLECODEID uniqueidentifier = null output,
    @BIRTHDATE dbo.UDT_FUZZYDATE = null output,
    @AGE int = null output,
    @MARITALSTATUSCODEID uniqueidentifier = null output,
    @OCCUPATION nvarchar(100) = null output,
    @CNOTES nvarchar(1024) = null output,
    @HOUSEHOLDMOSAIC nvarchar(100) = null output,
    @HOUSEHOLDINCOMECODEID uniqueidentifier = null output,
    @DISCRETIONARYSPENDING money = null output,
    @HHMEMBERS xml = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows
    set @DATALOADED = 0;
    set @TSLONG = 0;

    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @SOURCE = BD.SOURCE,
        @FIRSTNAME = BD.FIRSTNAME,
        @MIDDLENAME = BD.MIDDLENAME,
    @LASTNAME = BD.LASTNAME,
    @SUFFIXCODEID = BD.SUFFIXCODEID,
    @TITLECODEID = BD.TITLECODEID,
    @BIRTHDATE = BD.BIRTHDATE,
    @AGE = BD.AGE,
    @MARITALSTATUSCODEID = BD.MARITALSTATUSCODEID,
    @OCCUPATION = BD.OCCUPATION,
    @CNOTES = BD.CNOTES,
    @HOUSEHOLDMOSAIC = BD.HOUSEHOLD_MOSAIC,
    @HOUSEHOLDINCOMECODEID = BD.HOUSEHOLD_INCOMECODEID,
    @DISCRETIONARYSPENDING = BD.DISCRETIONARY_SPEND,
    @HHMEMBERS = dbo.UFN_WPBIOGRAPHICAL_GETHHMEMBERS2_TOITEMLISTXML(ID)
    from dbo.WPBIOGRAPHICALDEMOGRAPHIC BD
    where ID = @ID

    return 0;