USP_DATALIST_NETCOMMUNITY_TRANSACTIONPROCESSORS

            CREATE procedure dbo.USP_DATALIST_NETCOMMUNITY_TRANSACTIONPROCESSORS 
            as
                set nocount on;

                select
                    NETCOMMUNITYTRANSACTIONPROCESSOR.ID,
                    NETCOMMUNITYTRANSACTIONPROCESSOR.NAME as TRANNAME,
                    NETCOMMUNITYTRANSACTIONPROCESSOR.DESCRIPTION,
                    BATCHTEMPLATE.NAME as BATCHNAME,
                    NETCOMMUNITYTRANSACTIONPROCESSOR.SPLITTRANSACTIONS
                from
                    dbo.NETCOMMUNITYTRANSACTIONPROCESSOR
                inner join
                    dbo.BATCHTEMPLATE
                on
                    NETCOMMUNITYTRANSACTIONPROCESSOR.BATCHTEMPLATEID = BATCHTEMPLATE.ID
                order by
                    TRANNAME;