SP as a data source

• computercampuses

  SSC Rookie

  Points: 33

  More actions

  April 27, 2002 at 9:08 am

  #157619

  Hi. I'm new to your forum and SQL Server. I'm converting an Access 2000 .mdb to a SQL Server 2000 back-end and Access .adp front-end. Is there a way to use a stored procedure as the data source for another stored procedure? I know I can use a view as the data source for another view, but I haven't found a way to accomplish this. In one case, I need to be able to group & sum records from a table (based on criteria the end-user provides) and use that recordset as the data source for another procedure. I've considered creating a temporary table to use as my source for the second procedure, but I assume there must be a way of using a procedure as a source.

  Thanks for any help!

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  April 27, 2002 at 1:55 pm

  #427988

  Using a temp table isnt a bad way to go. You can do it easily using the insert...exec syntax. I think you can accomplish what you want more directly by using OpenRowset. Take a look at this thread:

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=1480&FORUM_ID=8&CAT_ID=1&Topic_Title=How%20to%20use%20results%20of%20an%20sp%20in%20another%20sp?&Forum_Title=T-SQL

  Andy

  Andy
  Connect with me on LinkedIn