Try to insert your colum name with rates on a temporary table or variable table.

Order by rate.

Output the ordered colum name on comma delimited list.

Insert the comma delimited list in...

I' am with a very similar issue.

We have migrated from 2005 to 2008, tough the database is with compatibility level=80.

Some views have got slow and are with different execution plans....

Yes, the problem was change the servername.

when select @@servername returns null, the jobs are not created.

I had the same issue and after i have corrected the servername the...