Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: KeithRichards
- Order by date
-
PROCEDURE WITH - WHILE DO STRUCTURE
Hi there, I have done some research on cursors and it has been good to expand the knowledge. I have been googling for a few days and I still can't find any examples that help... so I am still stuck! In the code below I have tried to merge what I originally had (in the earlier post) with the...- KeithRichards
- Post #8
- Forum: MySQL
-
PROCEDURE WITH - WHILE DO STRUCTURE
Awesome! I'll do some head scratching and then re-write it and see how I go. Cheers, K- KeithRichards
- Post #7
- Forum: MySQL
-
PROCEDURE WITH - WHILE DO STRUCTURE
Sorry to not make that clear. test.table would = table 2 in the data example I just sent through. Cheers, K- KeithRichards
- Post #5
- Forum: MySQL
-
PROCEDURE WITH - WHILE DO STRUCTURE
Hi r937, Thanks for your reply. I would attached a sample in excel but I'm not sure if that is possible? Anyway, I have included a small data sample and some commentary below.The main aim is to calculate the RESULT column below. 1. The first book_value function in the procedure is based on a...- KeithRichards
- Post #3
- Forum: MySQL
-
PROCEDURE WITH - WHILE DO STRUCTURE
I’m REALLY hoping someone can point me in the right direction with this procedure. I am using a While Do control structure to run a select statement based on the ID number of the database row. Simply, while the row ID = 1 then I want to run the first select statement which contains the function...- KeithRichards
- Thread
- Replies: 7
- Forum: MySQL
