Thanks Lynn. One more thing, I want to ask is that, how can we make the DEV team understand why not to do the sorting at DB layer and can push it to the application layer. Most people are very reluctant to do so and they want everything to me done(all kinds of massaging within stored proc iteself) and they just add the data set to the grid control or whatever ... they use it in the front end.. How to make them understand in a nice polite way.
This is really the main question here and you probably should have led with this. The only suggestion I have is to remind them of distributed processing.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA