select columns outcome set stored procedure

i have stored way advantage 80 columns, 300 rows. i wish name gets 2 those columns. something

select col1, col2 exec mystoredproc 'param1', 'param2'

when i used above syntax i error:

"invalid buttress name".

i know easiest fortitude change stored procedure, nonetheless i didn't it, i can't change it.

is there any proceed i want?

• i temp list put law in, nonetheless since there 80 columns i need an 80 buttress temp list only 2 columns. i wanted prevaricate tracking down columns returned.




• i attempted controlling with sprocresults .... suggested mark, nonetheless i got 2 errors
  

  
  
  

  
  

  incorrect syntax circuitously keyword 'exec'.
  incorrect syntax circuitously ')'.

  
  




• i attempted dogmatic list non-static i got following blunder
  

  
  
  

  
  

  insert error: buttress name array reputed values does review list definition

  
  




• if i try
  
  select * exec mystoredproc 'param1', 'param2'
  
  i blunder :
  

  
  
  

  
  

  incorrect syntax circuitously keyword 'exec'.