I'm using ms SQL Server and I was wondering if there is way to to order your query in a user specified way. For example, I have a table that looks like this.

Table: Names

Userid Name
1 Bob
2 Jen
3 Eric
4 Jeff
5 Tammy
6 Dave


And I want it to come out in this specific order of user id's: 3,1,6,5,2,4

Is this even possible?