Union Execute

• sxg6023

  SSCrazy

  Points: 2918

  More actions

  September 30, 2003 at 4:40 pm

  #162551

  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'

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  October 1, 2003 at 5:50 am

  #476527

  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