USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP_SELECT

This procedure is used to select business ownership results for a Prospect Quick Search criteria.

Parameters

Parameter	Parameter Type	Mode	Description
@PARTIALINFORMATIONSEARCHCRITERIAID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP_SELECT (
                    @PARTIALINFORMATIONSEARCHCRITERIAID uniqueidentifier
                ) as
                set nocount on;

                select
                        PISRBO.[ID],
                        PISRBO.[DUNSNUM]
                from
                    dbo.[PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP] PISRBO
                where
                    PISRBO.[PARTIALINFORMATIONSEARCHCRITERIAID] = @PARTIALINFORMATIONSEARCHCRITERIAID;

                return 0;