| nested stored procedures - Please help! [message #88198] |
Tue, 30 April 2002 19:25  |
Renu
Messages: 7
Registered: February 2002
|
Junior Member |
|
|
I have written a stored procedure ( GetFileTitle) that is going to go through a record, get the names of the parties, append them and send the result out under the heading 'file title'
I also have another stored procedure(GetRecDetails) that runs a select statement, getting info from 2 tables on the database. This returns info like Applic num, sequence etc.
I have tried to add -
exec GetFileTitle
- at the end of the select statement, but it comes up with an error
I have also tried to add -
union
exec GetFielTitle
- at the end of the bit of code, but that comes up with an error too.
Please help!!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
