Query on Sorting TSQ Data

dallasmavs · New User Joined: 17 Mar 2005 Posts: 3

have a TSQ which is populated from the database, want to give user the option to sort the TSQ and re-display the data.

One option is re-fetch the data from the database and display the screen, then I am doing lot of IO's when I have all the information in the TSQ.

Don't want to bubble sort, can not use sort-in and sort-out as this is not a batch module.

Can not use indexed option as I have to populate the data into an array in ascending or descending.

Cannot use temporary db2 tables as it will go away after each session.

Any ideas?

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 269 Location: India

I think,

The best option would be to write your own sort routine.
Heapsort or Quicksort can be a good choice.

Let me know if you have any better options in this case.