USP_WPSECURITIES_PRICE_UPDATE

Updates the price and value of a security record.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@TICKER	nvarchar(8)	IN
@CVALUE	money	IN
@AMOUNTOWNEDDIRECT	bigint	IN
@AMOUNTOWNEDINDIRECT	bigint	IN
@PRICEDIRECT	money	IN
@PRICEINDIRECT	money	IN
@VALUEDIRECT	money	IN
@VALUEINDIRECT	money	IN

Definition

Copy



            CREATE procedure dbo.USP_WPSECURITIES_PRICE_UPDATE (
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,
                @TICKER nvarchar(8) = '',
                @CVALUE money = 0,
                @AMOUNTOWNEDDIRECT bigint = 0,
                @AMOUNTOWNEDINDIRECT bigint = 0,
                @PRICEDIRECT money = 0,
                @PRICEINDIRECT money = 0,
                @VALUEDIRECT money = 0,
                @VALUEINDIRECT money = 0
            ) as begin
                set nocount on;

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                begin try    
                    declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                    update
                        dbo.WPSECURITIES
                    set
                        PRICEDIRECT = coalesce(nullif(@PRICEDIRECT, 0), PRICEDIRECT),
                        PRICEINDIRECT = coalesce(nullif(@PRICEINDIRECT, 0), PRICEINDIRECT),
                        VALUEDIRECT = coalesce(nullif(@VALUEDIRECT, 0), VALUEDIRECT),
                        VALUEINDIRECT = coalesce(nullif(@VALUEINDIRECT, 0), VALUEINDIRECT),
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        ID = @ID

                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                end catch

                return 0;
            end