fnTransactions_GetUnprocessedAdvocacy

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ClientID	int	IN

Definition

Copy



    CREATE function dbo.fnTransactions_GetUnprocessedAdvocacy(@ClientID int)
    returns table as

    return (

    select top 100 percent CapWizTransactionsID,DateLastChanged,XMLObjectData
    from dbo.CapWizTransactions where 
    ClientsID = @ClientID 
        and ProcessedDate is null
    order by CapWizTransactionsID 
    )