the problem was caused by the SpeakerOrder values not having leading 0s, so the order was being forced:
1
11
12
13
etc..
2
21
22
etc...
I changed the order by to add the leading 0s:
ORDER BY LPAD(CONVERT(SpeakerOrder,CHAR(3)),3,'0') ASC
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.