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 - 2001-06-29 : 07:24:01
|
| Allen writes "I have an SQL2000 database with 2 fields. One is a date field, the other is simple bit field (yes/no). The database has several records, but at any one time only at most one record will have the bit field set to "yes". What I want to do (and I'm writing to see if it can be done) is run a query that first looks to see if any record has a yes in the bit field, and if so returns that record, and if not returns a Recordset ordered by date. Is this possible without using multiple queries and thus using up more resources? Thanks!" |
|
|
|
|
|
Can I do conditional queries in one trip to the server?