http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/Niners/mnuber/Entries, comments and threads posted by mnuberhttp://channel9.msdn.com/Niners/mnuber/en-usWed, 31 Jan 2007 02:36:17 GMTWed, 31 Jan 2007 02:36:17 GMTEvNet (EvNet, Version=1.0.3608.3122, Culture=neutral, PublicKeyToken=null)Hey guys sorry to bother you, but I am a complete newbie at ASP and SQL, and I hope you guys could help me?<br><br>What I'm doing: <br><br>I have people and their scores in a table, what I would like to do is find the 10 closest scores in the table, does this make sense?<br>(SQL=...;)<br><br>Any help? :D<br><br>If it helps...<br>-table contains the colums: personID, person, pScore1 - pScore10, totalScore.<br><br>Thanks! I can answer any question you have to help you help me.<br><br><br><br>-mnuber<p>in reply to <a href='http://channel9.msdn.com/forums/TechOff/251868-SQL-newb-help-please/'>SQL (newb help please?)</a></p><img src="http://channel9.msdn.com/251868/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/forums/TechOff/251868-SQL-newb-help-please/http://channel9.msdn.com/forums/TechOff/251868-SQL-newb-help-please/Wed, 31 Jan 2007 02:36:17 GMThttp://channel9.msdn.com/forums/TechOff/251868-SQL-newb-help-please/1451http://channel9.msdn.com/251868/WebViewBug.aspx?EVT=0Hey guys sorry to bother you, but I am a complete newbie at ASP and SQL, and I hope you guys could help me?<br><br>What I'm doing: <br><br>I have people and their scores in a table, what I would like to do is find the 10 closest scores in the table, does this make sense?<br>(SQL=...<img src='/emoticons/C9/emotion-5.gif' alt='Wink' /><br><br>Any help? <img src='/emoticons/C9/emotion-2.gif' alt='Big Smile' /><br><br>If it helps...<br>-table contains the colums: personID, person, pScore1 - pScore10, totalScore.<br><br>Thanks! I can answer any question you have to help you help me.<br><br><br><br>-mnubermnuber5http://channel9.msdn.com/forums/TechOff/251868-SQL-newb-help-please/RSS/http://channel9.msdn.com/251868/Trackback.aspx