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 - 2005-09-26 : 07:56:37
|
| Doug writes "Hello This is an off the wall question but maybe you can shed some light on this, I have a project I'm working on, it is a personality matching web. I use asp to write 37 results to a sql database, these results consist of true or false answers, is there any way you can think of to write a query that would sort the closest matches by relevance ie: 37 matched of 1 personality sorted down to only 1 matched of personality. any help or advice to point me in the right direction would be greatly appreciated. thankyou" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-26 : 08:15:10
|
| Posting some sample data with expected result would be helpfulMadhivananFailing to plan is Planning to fail |
 |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2005-09-26 : 09:50:07
|
| It depends on your table structure. Hopefully it is properly normalized. Do you have already table structure sorted out? |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Compatability matching results