spTransactions_GetUnprocessedCustomCounts

Parameters

Parameter	Parameter Type	Mode	Description
@ClientID	int	IN
@TransactionTypeGuid	uniqueidentifier	IN

Definition

Copy



    create PROCEDURE dbo.spTransactions_GetUnprocessedCustomCounts(
        @ClientID int, 
        @TransactionTypeGuid uniqueidentifier)
    as

    select count(*) as [count] from dbo.CustomTransactions 
    where 
        dateprocessed is null
        and TransactionTypeGuid=@TransactionTypeGuid