April 27, 2002 at 9:08 am
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!
April 27, 2002 at 1:55 pm
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:
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply