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-01-09 : 15:49:54
|
Matt Baldwin writes "Hello,
I've got a question. To this may not be the hardest question ever but to me its a stumper. I need to create a query that checks five parameters to see if they match. For a record to be returned it must match on at least two of the five parameters. I would like to order the results from the most matches to the least and do this as cleanly as possible. I hope this made sense. I hope you can help me!
ps: 3 of the fields are alpha-numeric, 2 of them are numeric
I am using SQL Server 7.0 and Windows NT.
Thanks,
Matt Baldwin" |
|
|
|
|
|
The hardest SQL question ever!