Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: use stored procedure results in select query
Started 1 month, 2 weeks ago by Marc Ozin
Hi All, Is something like this possible? select sName from tblcategories where iCategoryID in (call spCategoryListChildIDs(52)); Basically I've got a stored procedure that lists the IDs of all the children of a given parent category id. The example query above uses this (if it worked) SP to list the category names instead of their IDs Please excuse me if the answer's ...
Site: MySQL AB - MySQL Forums  MySQL AB - MySQL Forums - site profile
Forum: Stored Procedures  Stored Procedures - forum profile
Total authors: 2 authors
Total thread posts: 3 posts
Thread activity: no new posts during last week
Domain info for: mysql.com

Other posts in this thread:

Peter Brawley replied 1 month, 2 weeks ago
>Is something like this possible? >select sName from tblcategories where iCategoryID in (call spCategoryListChildIDs(52)); Alas not in MySQL. Have the sproc save its results to a temp table, call the sproc, and join to that table. PB http://www.artfulsoftware.com
Size: 379 bytes
Customize:  Customize "<b>Reply 1</b>: Re: use stored procedure results in select query :: Stored Procedures :: MySQL AB - MySQL Forums"

Marc Ozin replied 1 month, 2 weeks ago
Hi Peter, Thanks for the clarifcation and the suggestion. All the best M.
Size: 115 bytes
Customize:  Customize "<b>Reply 2</b>: Re: use stored procedure results in select query :: Stored Procedures :: MySQL AB - MySQL Forums"

 

Top contributing authors

Name
Posts
Marc Ozin
2
user's latest post:
Re: use stored procedure results...
Published (2009-11-06 12:09:00)
Hi Peter, Thanks for the clarifcation and the suggestion. All the best M.
Peter Brawley
1
user's latest post:
Re: use stored procedure results...
Published (2009-11-05 15:30:00)
&gt;Is something like this possible? &gt;select sName from tblcategories where iCategoryID in (call spCategoryListChildIDs(52)); Alas not in MySQL. Have the sproc save its results to a temp table, call the sproc, and join to that table. PB http://www.artfulsoftware.com

Related threads on "MySQL AB - MySQL Forums":

Error calling Stored Procedure "SELECT in a stored...  MySQL AB - MySQL Forums - site profile JDBC - forum profile Error calling Stored Procedure "SELECT in a stored procedure must have INTO "
Error calling Stored Procedure "SELECT in a stored procedure must have INTO "
STORED PROCEDURE SELECT RESULTSET  MySQL AB - MySQL Forums - site profile Newbie - forum profile STORED PROCEDURE SELECT RESULTSET
STORED PROCEDURE SELECT RESULTSET
How to use like in the stored procedure select statement???  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile How to use like in the stored procedure select statement???
How to use like in the stored procedure select statement???
Stored procedure SELECT  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Stored procedure SELECT
Stored procedure SELECT
Error 1406 'data too long for column' on stored procedure...  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Error 1406 'data too long for column' on stored procedure SELECT
Error 1406 'data too long for column' on stored procedure SELECT
How to parse multiple stored procedure in query browser?  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile How to parse multiple stored procedure in query browser?
How to parse multiple stored procedure in query browser?
Cannot see stored procedure in Query Browser - bug?  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Cannot see stored procedure in Query Browser - bug?
Cannot see stored procedure in Query Browser - bug?
Does not showing the stored procedure in Query Browser  MySQL AB - MySQL Forums - site profile QA - forum profile Does not showing the stored procedure in Query Browser
Does not showing the stored procedure in Query Browser
Using SELECT query in Stored Procedure  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Using SELECT query in Stored Procedure
Using SELECT query in Stored Procedure
Retrieve a select from a stored procedure.  MySQL AB - MySQL Forums - site profile C/C++ - forum profile Retrieve a select from a stored procedure.
Retrieve a select from a stored procedure.

Related threads on other sites:

Variable not being passed to stored procedure or query...  Discussions in microsoft.public.vb.database.ado - site profile microsoft.public.vb.database.ado - forum profile Variable not being passed to stored procedure or query in microsoft.public.vb.database.ado
Variable not being passed to stored procedure or query in microsoft.public.vb.database.ado
MSSQL 2000 - stored procedure or query  Database Journal Forums - site profile Ask an Expert - forum profile MSSQL 2000 - stored procedure or query
MSSQL 2000 - stored procedure or query
Stored Procedure Select and Update ? in...  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile Stored Procedure Select and Update ? in microsoft.public.sqlserver.programming
Stored Procedure Select and Update ? in microsoft.public.sqlserver.programming
Stored procedure select permission without table access...  SQLServerCentral - site profile SQL Server 2005 Security - forum profile Stored procedure select permission without table access (using sp_executesql)
Stored procedure select permission without table access (using sp_executesql)
Stored Procedure / SQL Query listing all views and...  SQLServerCentral - site profile T-SQL - forum profile Stored Procedure / SQL Query listing all views and underlying views
Stored Procedure / SQL Query listing all views and underlying views
Measure Aggregator types in Analysis Services Stored...  SQLServerCentral - site profile Business Intelligence - forum profile Measure Aggregator types in Analysis Services Stored Procedure Discover query
Measure Aggregator types in Analysis Services Stored Procedure Discover query
Stored procedure and Query Analyser give different...  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile Stored procedure and Query Analyser give different results in microsoft.public.sqlserver.programming
Stored procedure and Query Analyser give different results in microsoft.public.sqlserver.programming
Stored Procedure - Ejecutar Query de Una Variable  Foros del Web - site profile MySQL - forum profile Stored Procedure - Ejecutar Query de Una Variable
Stored Procedure - Ejecutar Query de Una Variable
DB2 Stored Procedure Select  Expert Communities - bytes - site profile db2 - forum profile DB2 Stored Procedure Select
DB2 Stored Procedure Select
Stored Procedure SELECT Statement Error  Expert Communities - bytes - site profile mysql - forum profile Stored Procedure SELECT Statement Error
Stored Procedure SELECT Statement Error
Thread profile page for "use stored procedure results in select query" on http://www.mysql.com. This report page is a snippet summary view from a single thread "use stored procedure results in select query", located on the Message Board at http://www.mysql.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity