USP_DATALIST_PARTIALINFORMATIONSEARCHBUSINESSOWNERSHIPDETAILBIOS

Returns a list of bios for a company that has a business ownership record.

Parameters

Parameter	Parameter Type	Mode	Description
@PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PARTIALINFORMATIONSEARCHBUSINESSOWNERSHIPDETAILBIOS(
    @PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID uniqueidentifier
)
as
    set nocount on;

    select 
        BIOS.ID,
        BIOS.NAME
    from 
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_BIOS BIOS
    join
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL DETAIL on DETAIL.ID = BIOS.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID
    where 
        DETAIL.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID = @PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID