Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-29 : 09:37:09
|
AG writes "I am trying to create a series of qry's that keep tracks of patient who went through the screening process from step A to step D. qryBaseA and qryBaseB are created in views, and qryBaseA is a subqry of qryBaseB. qryBaseC is a stored procedure that calls qryBaseB which calls qryBaseA. Now, I need to create a qry that calls qryBaseC. How do I go about in created a 3rd/4th level qry?
I created qryBaseC in stored procedure bc I was unable to do it in View. When I created qryBaseC, I copied the SQL statement from Access Project and paste it on a stored procedure. Please advise on how to tackle nested qry's.
Thanks." |
|
|
|
|
|
Nested qry's in stored procedure