Using SELECT with a SP

• inversekinematics

  SSC Journeyman

  Points: 94

  More actions

  August 26, 2005 at 9:35 am

  #89587

  Hi!

  I have a stored procedure with parameters, and I wonder if there is any way of using SELECT with that SP?

  Like this or something:

  SELECT col1,col2,sum(col3) as output FROM

  EXEC sp_theSP 'temp','2005-05-01','2005-05-10'

  group by col1,col2,output

  Above there's syntax errors, but is it possible to do this way?

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 26, 2005 at 9:41 am

  #585483

  convert the sp to a table function and it'll work.