USP_DATALIST_WEALTHINFORMATIONDASHBOARDBUSINESSOWNERSHIP_BIO2

This datalist returns WealthPoint business ownership biography information that is used by the wealth information dashboard.

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSOWNERSHIPID	uniqueidentifier	IN	Business Ownership ID

Definition

Copy



                create procedure dbo.USP_DATALIST_WEALTHINFORMATIONDASHBOARDBUSINESSOWNERSHIP_BIO2
                (
                    @BUSINESSOWNERSHIPID uniqueidentifier
                )
                as
                    set nocount on;

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