USP_DATAFORMTEMPLATE_VIEW_WPSECURITIES_2

The load procedure used by the view dataform template "WealthPoint Securities View Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CDATE	datetime	INOUT	BBA confirmed date
@CVALUE	money	INOUT	BBA confirmed value
@CNOTES	nvarchar(1024)	INOUT	Notes
@FULLNAME	nvarchar(60)	INOUT	Name
@CUSIP	nvarchar(9)	INOUT	Cusip
@FILERID	nvarchar(20)	INOUT	Filer ID
@RELATIONSHIP	nvarchar(50)	INOUT	Relationship
@TICKER	nvarchar(8)	INOUT	Symbol
@ISSUERNAME	nvarchar(60)	INOUT	Issuer name
@REPORTDATEDIRECT	datetime	INOUT	Last transaction date
@REPORTDATEINDIRECT	datetime	INOUT	Last transaction date
@AMOUNTOWNEDDIRECT	bigint	INOUT	Quantity held
@AMOUNTOWNEDINDIRECT	bigint	INOUT	Quantity held
@PRICEDIRECT	money	INOUT	Last retrieved price
@PRICEINDIRECT	money	INOUT	Last retrieved price
@VALUEDIRECT	money	INOUT	Value
@VALUEINDIRECT	money	INOUT	Value
@UPDATEDVALUE	money	INOUT	Updated value
@UPDATEDDATE	datetime	INOUT	Updated date
@UPDATEDPRICE	money	INOUT	Updated price

Definition

Copy


          CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WPSECURITIES_2 (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
                      @CDATE datetime = null output,
                      @CVALUE money = null output,
                      @CNOTES nvarchar(1024) = null output,
                      @FULLNAME nvarchar(60) = null output,
                      @CUSIP nvarchar(9) = null output,
                      @FILERID nvarchar(20) = null output,
                      @RELATIONSHIP nvarchar(50) = null output,
                      @TICKER nvarchar(8) = null output,
                      @ISSUERNAME nvarchar(60) = null output,
                      @REPORTDATEDIRECT datetime = null output,
                      @REPORTDATEINDIRECT datetime = null output,
                      @AMOUNTOWNEDDIRECT bigint = null output,
                      @AMOUNTOWNEDINDIRECT bigint = null output,
                      @PRICEDIRECT money = null output,
                      @PRICEINDIRECT money = null output,
                      @VALUEDIRECT money = null output,
                      @VALUEINDIRECT money = null output,
                      @UPDATEDVALUE money = null output,
                      @UPDATEDDATE datetime = null output,
                      @UPDATEDPRICE money = null output
                  ) as begin    

                      set nocount on;

                      set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @CDATE = CDATE,
                        @CVALUE = CVALUE,
                        @CNOTES = CNOTES,
                        @FULLNAME = FULLNAME,
                        @CUSIP = CUSIP,
                        @FILERID = FILERID,
                        @RELATIONSHIP = RELATIONSHIP,
                        @TICKER = TICKER,
                        @ISSUERNAME = ISSUERNAME,
                        @REPORTDATEDIRECT = REPORTDATEDIRECT,
                        @REPORTDATEINDIRECT = REPORTDATEINDIRECT,
                        @AMOUNTOWNEDDIRECT = AMOUNTOWNEDDIRECT,
                        @AMOUNTOWNEDINDIRECT = AMOUNTOWNEDINDIRECT,
                        @PRICEDIRECT = PRICEDIRECT,
                        @PRICEINDIRECT = PRICEINDIRECT,
                        @VALUEDIRECT = VALUEDIRECT,
                        @VALUEINDIRECT = VALUEINDIRECT,
                        @UPDATEDVALUE = case UPDATEDVALUEDIRECT when 0 then UPDATEDVALUEINDIRECT else UPDATEDVALUEDIRECT end,
                        @UPDATEDDATE = UPDATEDDATE,
                        @UPDATEDPRICE = UPDATEDPRICE
                    from
                        dbo.WPSECURITIES
                    where
                        ID=@ID;

                    return 0;

                end