USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILEXECS_INSERT

This procedure is used to insert a Prospect Quick Search business ownership executive result.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID	uniqueidentifier	IN
@FIRST	nvarchar(50)	IN
@LAST	nvarchar(50)	IN
@MIDDLE	nvarchar(50)	IN
@PREFIX	nvarchar(50)	IN
@SUFFIX	nvarchar(50)	IN
@TITLE	nvarchar(100)	IN
@YEAROFBIRTH	int	IN
@GENDERCODE	smallint	IN
@ADDRESS	nvarchar(100)	IN
@CITY	nvarchar(50)	IN
@STATE	nvarchar(2)	IN
@ZIP	nvarchar(10)	IN

Definition

Copy



            create procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILEXECS_INSERT(
                @ID uniqueidentifier output,
                @CHANGEAGENTID uniqueidentifier,
                @PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID uniqueidentifier = null,
                @FIRST nvarchar(50) = '',
                @LAST nvarchar(50) = '',
                @MIDDLE nvarchar(50) = '',
                @PREFIX nvarchar(50) = '',
                @SUFFIX nvarchar(50) = '',
                @TITLE nvarchar(100) = '',
                @YEAROFBIRTH integer = 0,
                @GENDERCODE smallint = 0,
                @ADDRESS nvarchar(100) = '',
                @CITY nvarchar(50) = '',
                @STATE nvarchar(2) = '',
                @ZIP nvarchar(10) = ''
            )
            as
            begin
                set nocount on;

                declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                begin try
                    if @ID is null
                        set @ID = newid();
                        insert into dbo.[PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_EXECS] (
                            [ID],
                            [PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID],
                            [FIRST],
                            [LAST],
                            [MIDDLE],
                            [PREFIX],
                            [SUFFIX],
                            [TITLE],
                            [YEAROFBIRTH],
                            [GENDERCODE],
                            [ADDRESS],
                            [CITY],
                            [STATE],
                            [ZIP],
                            [ADDEDBYID],
                            [CHANGEDBYID],
                            [DATEADDED],
                            [DATECHANGED]
                        )
                        values (
                            @ID,
                            @PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID,
                            @FIRST,
                            @LAST,
                            @MIDDLE,
                            @PREFIX,
                            @SUFFIX,
                            @TITLE,
                            @YEAROFBIRTH,
                            @GENDERCODE,
                            @ADDRESS,
                            @CITY,
                            @STATE,
                            @ZIP,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                        );
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;
            end