USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILOWNERSHIP_SELECT
This procedure is used to select business ownership result ownership details for a business ownership result.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILOWNERSHIP_SELECT(
@ID uniqueidentifier
)
as
begin
select
O.PERCENTOWNERSHIP,
O.NAME
from
dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_OWNERSHIP O
inner join
dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL BOD on BOD.ID = O.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID
where
BOD.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID = @ID
end