Select in SQL then use data to loop

Asked Oct 10 '13 at 18:32

Active Oct 10 '13 at 18:39

Viewed 213 times

I have a select statement that obviously pulls some results from my database. Once I get those results, I would like to access them one at a time for another Select statement, is that possible? I am doing this in a user defined function.

Example:

SELECT differentKindsOfBread FROM breadDrawer
WHERE differentKindsOfBread IS NOT Null

Now I want to use my results to do another Select like:

SELECT differentKindsOfBread[1] FROM differentKindsOfBread
WHERE blah = blahblah

EDIT Lets say differentKindsOfBread selected:

 Rye
 White
 Wheat
 half-Wheat

Now I want to do selects for each one like:

Select Rye (differntKindsOfBread[0]) ...
Select White (differntKindsOfBread[1]) ...

Thanks,

edited Oct 10 '13 at 18:39

asked Oct 10 '13 at 18:32

eanderson

I am really sorry. My answer was for SQL Server. I just noticed you are using a different server. – Giannis Paraskevopoulos Oct 10 '13 at 18:42
any other solutions? :p – eanderson Oct 10 '13 at 18:42
It seems it is close to SQL Server. Would you care to check this http://www.developitnow.com/Articles/tabid/280/EntryId/11/How-to-Create-a-Pervasive-10-Cursor.aspx – Giannis Paraskevopoulos Oct 10 '13 at 18:45
What is your ultimate goal here? – JDB Oct 10 '13 at 18:53
my goal is to select rows using one select statement, then using each row from that selection, do another selection on each row from the first selection. I think a nested select statement would work? – eanderson Oct 11 '13 at 12:03

Select in SQL then use data to loop

0 Answers0