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-10-26 : 20:30:45
|
Thierry writes "I use Win2k and SQL Server 7
I need to select records in a table based on a criteria which is different for each one of them: for example I have an applicant to several schools, and i need to test a different criteria for each school in order to select the subset of schools ready to accept the student. This criteria is fixed for each school, and I thought of directly storing it as a SQL query in a field of the school table.
What query can I then use to select all the schools for which this criteria is met ??
I tried creating a stored procedure which evaluates the query, but I can't find a way to use the result of this sp in another query." |
|
|
|
|
|
selecting on different criteria for each row