USP_DATALIST_PARTIALINFORMATIONSEARCHBUSINESSOWNERSHIPDETAILOWNERSHIP

Returns a list of ownership records 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_PARTIALINFORMATIONSEARCHBUSINESSOWNERSHIPDETAILOWNERSHIP(
    @PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID uniqueidentifier
)
as
    set nocount on;

    select 
        OWNERSHIP.ID,
        OWNERSHIP.NAME,
        OWNERSHIP.PERCENTOWNERSHIP,
        (DETAIL.VALUATION * OWNERSHIP.PERCENTOWNERSHIP/100) as VALUE
    from 
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_OWNERSHIP OWNERSHIP
    join
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL DETAIL on DETAIL.ID = OWNERSHIP.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID
    where 
        DETAIL.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID = @PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID