Thanks, actually I always take a good luck at the optimizer plan, just trying to show an alternative to embedding case statements in the order by. But yes, if it...

I was wrong on using the CTE suggestion after working it through. Since I usually avoid doing case statements on order by ordinarily. Here is a proposed alternative to consider:

DECLARE...

I usually build the data via a CTE so I do not then need to worry about using case statements on the order by. But, good article, and interesting.

Regards;

Jeremy

Wouldn't that depend on how much data needs to be processed, how many CPU's are available on the server doing the processing, and how many servers which need to be...

Very nice Article. I used a Registered server mechanism to scroll through all the servers to get information. This allowed the client to get information dynamically whenever they added a...