USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_INSERT

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

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID	uniqueidentifier	IN
@PARENT	nvarchar(30)	IN
@SECNAME	nvarchar(30)	IN
@DESCRIPTION	nvarchar(300)	IN
@MAILINGADDRESS	nvarchar(25)	IN
@MAILINGCITY	nvarchar(20)	IN
@MAILINGSTATE	nvarchar(2)	IN
@MAILINGZIP	nvarchar(5)	IN
@MAILINGZIP4	nvarchar(4)	IN
@PRIMARYSICCODE	nvarchar(20)	IN
@YEARSTARTED	smallint	IN
@NUMEMPLOYEES	int	IN
@HELDCODE	tinyint	IN
@SALES	money	IN
@RATIO	decimal(20, 4)	IN
@VALUATION	money	IN

Definition

Copy



            CREATE procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_INSERT(
                @ID uniqueidentifier output,
                @CHANGEAGENTID uniqueidentifier,
                @PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID uniqueidentifier,
                @PARENT nvarchar(30) = '',
                @SECNAME nvarchar(30) = '',
                @DESCRIPTION nvarchar(300) = '',
                @MAILINGADDRESS nvarchar(25) = '',
                @MAILINGCITY nvarchar(20) = '',
                @MAILINGSTATE nvarchar(2) = '',
                @MAILINGZIP nvarchar(5) = '',
                @MAILINGZIP4 nvarchar(4) = '',
                @PRIMARYSICCODE nvarchar(20) = '',
                @YEARSTARTED smallint = 0,
                @NUMEMPLOYEES int = 0,
                @HELDCODE tinyint = 0,
                @SALES money = 0,
                @RATIO decimal(20,4) = 0,
                @VALUATION money = 0
            )
            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] (
                            [ID],
                            [PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID],
                            [PARENT],
                            [SECNAME],
                            [DESCRIPTION],
                            [MAILINGADDRESS],
                            [MAILINGCITY],
                            [MAILINGSTATE],
                            [MAILINGZIP],
                            [MAILINGZIP4],
                            [PRIMARYSICCODE],
                            [YEARSTARTED],
                            [NUMEMPLOYEES],
                            [HELDCODE],
                            [SALES],
                            [RATIO],
                            [VALUATION],
                            [ADDEDBYID],
                            [CHANGEDBYID],
                            [DATEADDED],
                            [DATECHANGED]
                        )
                        values (
                            @ID,
                            @PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID,
                            @PARENT,
                            @SECNAME,
                            @DESCRIPTION,
                            @MAILINGADDRESS,
                            @MAILINGCITY,
                            @MAILINGSTATE,
                            @MAILINGZIP,
                            @MAILINGZIP4,
                            @PRIMARYSICCODE,
                            @YEARSTARTED,
                            @NUMEMPLOYEES,
                            @HELDCODE,
                            @SALES,
                            @RATIO,
                            @VALUATION,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                        );
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;
            end