USP_WPSECURITIES_PRICE_SELECT

Selects data for updating the price and value of a security.

Parameters

Parameter	Parameter Type	Mode	Description
@WEALTHID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_WPSECURITIES_PRICE_SELECT(
                @WEALTHID uniqueidentifier
            ) as begin
                set nocount on;

                select
                    ID,
                    TICKER,
                    CVALUE,
                    AMOUNTOWNEDDIRECT,
                    AMOUNTOWNEDINDIRECT
                from
                    dbo.WPSECURITIES
                where
                    WEALTHID = @WEALTHID

                return 0;

            end;