Hooker Posted August 1, 2008 Share Posted August 1, 2008 I have a table of "jobs" and a trigger to start the proceedure when a record is inserted into the table, the proceedure is passed the UID of the entry. I was wondering if there is a way to use a SELECT statement to find that record and then assign several variables within a stored proceedure based on the result set (one record, 5 fields). Quote Link to comment Share on other sites More sharing options...
fenway Posted August 5, 2008 Share Posted August 5, 2008 Variables? Huh? Quote Link to comment Share on other sites More sharing options...
Hooker Posted August 5, 2008 Author Share Posted August 5, 2008 Oops, forgot to flag this as solved, i already worked it out using a CURSOR. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.