USP_PARTIALINFORMATIONSEARCH_GETRESULTIDFROMEXECID

Returns the corresponding PQS business ownership result ID for a given business ownership detail executive ID.

Parameters

Parameter	Parameter Type	Mode	Description
@RESULTID	uniqueidentifier	INOUT
@EXECID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_PARTIALINFORMATIONSEARCH_GETRESULTIDFROMEXECID(
    @RESULTID uniqueidentifier = null output,
    @EXECID uniqueidentifier = null
)
as begin

    select
        @RESULTID = D.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID
    from 
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_EXECS E
    join
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL D on D.ID = E.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID
    where
        E.ID = @EXECID

end