Union Execute

  • Can yo do union of the output of stored procedures (their output is of matching type).

    Something like

    exec prc_get_orders '101' UNION exec prc_get_orders '102' UNION exec prc_get_orders '103'

  • You could insert the results into the same temporary table, then use SELECT DISTINCT if you want a true union result set instead of UNION ALL.

    --Jonathan



    --Jonathan

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply