spTransactions_DeleteCustomTransaction

Parameters

Parameter	Parameter Type	Mode
@TransactionTypeGuid	uniqueidentifier	IN
@TransactionId	int	IN
@ClientsID	int	IN

Definition

Copy



        create procedure dbo.spTransactions_DeleteCustomTransaction(
            @TransactionTypeGuid    uniqueidentifier,
            @TransactionId            integer,
            @ClientsID                 integer)
        as
        begin
            if (@TransactionId > 0)
                delete from dbo.CustomTransactions
                where TransactionTypeGuid = @TransactionTypeGuid
                and CustomTransactionID = @TransactionId
                and ClientsID = @ClientsID
            else
                delete from dbo.CustomTransactions
                where TransactionTypeGuid = @TransactionTypeGuid
                and ClientsID = @ClientsID
        end