USP_DATAFORMTEMPLATE_VIEW_WPSECURITIES_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@CDATE	datetime	INOUT
@SOURCE	nvarchar(100)	INOUT
@CVALUE	money	INOUT
@CNOTES	nvarchar(1024)	INOUT
@FULLNAME	nvarchar(60)	INOUT
@CUSIP	nvarchar(9)	INOUT
@FILERID	nvarchar(20)	INOUT
@RELATIONSHIP	nvarchar(50)	INOUT
@TICKER	nvarchar(8)	INOUT
@ISSUERNAME	nvarchar(60)	INOUT
@REPORTDATEDIRECT	datetime	INOUT
@REPORTDATEINDIRECT	datetime	INOUT
@AMOUNTOWNEDDIRECT	bigint	INOUT
@AMOUNTOWNEDINDIRECT	bigint	INOUT
@PRICEDIRECT	money	INOUT
@PRICEINDIRECT	money	INOUT
@VALUEDIRECT	money	INOUT
@VALUEINDIRECT	money	INOUT
@UPDATEDVALUE	money	INOUT
@UPDATEDDATE	datetime	INOUT
@UPDATEDPRICE	money	INOUT
@MATCHCODE	nvarchar(100)	INOUT

Definition

Copy


          CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WPSECURITIES_3 (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
                      @CDATE datetime = null output,
                        @SOURCE nvarchar(100) = 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,
                        @MATCHCODE nvarchar(100) = null output
                  ) as begin    

                      set nocount on;

                      set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @CDATE = CDATE,
                        @CVALUE = CVALUE,
                        @SOURCE = SOURCE,
                        @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,
                        @MATCHCODE = MC + ' - ' + dbo.UFN_WPMATCHCODE_DESCRIPTION(MC)
                    from
                        dbo.WPSECURITIES
                    where
                        ID=@ID;

                    return 0;

                end