USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILBIOS_SELECT

create procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILBIOS_SELECT(
    @ID uniqueidentifier
)
as
begin
    select
        B.BIO,
        B.NAME,
        B.LAST,
        B.FIRST,
        B.MIDDLE,
        B.SUFFIX
    from
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_BIOS B
    inner join
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL BOD on BOD.ID = B.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID
    where
        BOD.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID = @ID

end