the sp name makes me think this is a generic routine for calling programs.

prep and execute something. In this case a gross profit report by customer order.

I would like to replace the parameters with hard coded values to test this.

But I'm not sure how to identify all the parm values.

Its trial and error time I guess.

I did take your suggestion and read the BOL on UNION.

A big thanks for that kick in the pants 🙂

In any case thank you for taking the time to help me out.

-Todd