USP_CREDITCARDRECONCILIATION_GETVENDORIDS

create procedure dbo.USP_CREDITCARDRECONCILIATION_GETVENDORIDS
as
begin
    set nocount on;
    select distinct VENDORID from dbo.PROCESSORTRANSACTIONSETTLEMENTIMPORTROW where VENDORID != ''

end