USP_WEALTHPOINT_SEARCHHISTORY_GETMETADATA

Gets WealthPoint search metadata from the WealthPoint Search History table.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATESUBMITTED	datetime	INOUT
@DATESTARTED	datetime	INOUT
@DATEREADY	datetime	INOUT
@DATERETRIEVED	datetime	INOUT
@STATUSCODE	tinyint	INOUT
@SEARCHTYPECODE	tinyint	INOUT
@RECORDCOUNT	int	INOUT

Definition

Copy



            create procedure dbo.USP_WEALTHPOINT_SEARCHHISTORY_GETMETADATA(
                @ID uniqueidentifier,
                @DATESUBMITTED datetime = null output,
                @DATESTARTED datetime = null output,
                @DATEREADY datetime = null output,
                @DATERETRIEVED datetime = null output,
                @STATUSCODE tinyint = 0 output,
                @SEARCHTYPECODE tinyint = 0 output,
                @RECORDCOUNT int = 0 output
            ) as
            begin
                select
                    @DATESUBMITTED = DATESUBMITTED,
                    @DATESTARTED = DATESTARTED,
                    @DATEREADY = DATEREADY,
                    @DATERETRIEVED = DATERETRIEVED,
                    @STATUSCODE = STATUSCODE,
                    @SEARCHTYPECODE = SEARCHTYPECODE,
                    @RECORDCOUNT = RECORDCOUNT
                from 
                    dbo.WPSEARCHHISTORY
                where 
                    ID = @ID
            end