spTransactions_GetUnprocessedCustomTransactionForUser

Parameters

Parameter	Parameter Type	Mode
@ClientID	int	IN
@TransactionTypeGuid	uniqueidentifier	IN
@TransactionId	int	IN
@UserId	int	IN
Definition

Copy


CREATE  procedure [dbo].[spTransactions_GetUnprocessedCustomTransactionForUser](
        @ClientID                 integer,
        @TransactionTypeGuid     uniqueidentifier,
        @TransactionId             integer,
        @UserId                 integer)
    as
    begin

    set nocount on

    if (@TransactionId > 0)
        select top 100 percent 
        ctran.TransactionTypeGuid, 
        ctran.CustomTransactionID, 
        ctran.DateProcessed,
            ctran.AddedByUserID, 
        ctran.Data, 
        dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(ctran.addedbyuserid)
        from dbo.CustomTransactions ctran
        where ctran.ClientsID = @ClientID
        and ctran.dateProcessed is null
        and ctran.TransactionTypeGuid = @TransactionTypeGuid
        and ctran.CustomTransactionID = @TransactionID
        and ctran.AddedByUserID = @UserId
        order by ctran.CustomTransactionID
    else
        select top 100 percent 
        ctran.TransactionTypeGuid, 
        ctran.CustomTransactionID, 
        ctran.DateProcessed,
            ctran.AddedByUserID, 
        ctran.Data, 
        dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(ctran.addedbyuserid)
        from dbo.CustomTransactions ctran
        where ctran.ClientsID = @ClientID
        and ctran.dateProcessed is null
        and ctran.TransactionTypeGuid = @TransactionTypeGuid
        and ctran.AddedByUserID = @UserId
        order by ctran.CustomTransactionID
    end