I'm using stored procedures to process commands and then return a result set to
an ASP page. The result set is 10 columns, and the user needs to be able to sort
by any column. How do I pass the field to sort by into the stored procedure so
that it will return the correctly sorted recordset. (or what syntax do I use). I
looked into sorting the script recordset but didn't see a way to do that.