USP_DATALIST_BUSINESSOWNERSHIPBIOS

Returns a list of bios associated with a business ownership record.

Parameters

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

Definition

Copy



create procedure dbo.USP_DATALIST_BUSINESSOWNERSHIPBIOS(
    @WPBUSINESSOWNERSHIPID uniqueidentifier
)
as
    set nocount on;

    select 
        BIOS.ID,
        BIOS.NAME,
        BIOS.BIO
    from 
        dbo.WPBUSINESSOWNERSHIPBIOS BIOS
    where
        BIOS.WPBUSINESSOWNERSHIPID = @WPBUSINESSOWNERSHIPID