USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILEXECS_SELECT

CREATE procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILEXECS_SELECT(
    @ID uniqueidentifier
)
as
begin
    select
        E.PREFIX,
        E.FIRST,
        E.MIDDLE,
        E.LAST,
        E.SUFFIX,
        E.TITLE,
        E.YEAROFBIRTH,
        E.GENDERCODE,
        E.ADDRESS as LINE1,
        E.CITY,
        E.STATE,
        E.ZIP,
        dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS(E.ADDRESS, '', E.CITY, E.STATE, E.ZIP) as ADDRESS
    from
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_EXECS E
    inner join
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL BOD on BOD.ID = E.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID
    where
        BOD.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID = @ID or E.ID = @ID

end