Tiffany,

I assume you are using a Query Data workflow activity?  There are two options; create a view in SQL that returns the records sorted in the correct order and select that view in the Query Data activity, or use the Custom Query workflow activity and use a custom SQL query to return the records sorted in the correct order.