Getting results from a Procedure to join to a query

• bswhipp

  Ten Centuries

  Points: 1143

  More actions

  July 10, 2026 at 3:07 pm

  #4889382

  I have a need to execute a stored procedure and return the results to something I can join to in a query. I am trying to execute a Trial balance from our ERP and get those balances and account numbers to correlate to another table with new account numbers.

  So my stored procedure execution looks like this

  exec M2MData01.M2MReport.RPGLTB

  '1=1', 'A', 'GLMAST.FACCTNUM', '','','','01/01/1900', '01/01/1900', '#rpgltb_final.FCACCTNUM', 'baldate', '2026-07-10', '1=1', 301521)

  Thank you to anyone that can help.