SELECT *
FROM Mytable
ORDER BY
userID, Date
I assume Date is really a date/time type and not varchar...
gbn
- 70.1k
- 8
- 165
- 242