I have a stored procedure that returns a recordset that is used in various ASP forms.
Depending on where I am displaying the results I need to sort them differently.
My current SQL Statement in ASP/VBscript looks like this:
SQLStmt = "exec dbo.usp_CurrentWasteOrderRecords " & v_siteid & ";"
Is there a way of adding and ORDER BY statement to this. If not, how do I go about Sorting the records outside the stored procedure?