Hi All, Is it possible to sort the select query by index?
In our organization , we have one CMS system we dont have it source code,and most of the database query in that application are written as T SQL not stored procedures. So I need to change the sort order of a SELECT query,Using query profiler , i have found that query ,I cant able to add any extra order by clause to that query because i dont have any source code of that web site.Now its sorting based on primary key (here Pid) My question is , is it possble to alter the default sort order ? In Below table I need to sort it based on column *Type* instead of the default primary key (Clustered index) ie *Pid* Pid Name Type 1 DFG A 2 HJKL C 3 EWW B 4 WER B 5 ASD A 6 ASD C 7 ZCV A -- "People who never make mistakes, never do anything." dEv
