Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BendJoe
Posting Yak Master
128 Posts |
 Posted - 2012-03-30 : 12:10:28
|
| Look at this query,Select '0' as Id, 'Select Name' as Name union Select Id,Name from table order by Name.This one is ordering the entire result. What I need is to order the second part of the union alone,so that I can display the result in a dropdown list with 'Select Name' always on top and then the rest of the result sorted. How can I do this.Thanks |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2012-04-03 : 20:52:51
|
| You should really add the "select name" to your list in the UI, not try to force it into the query. I know some of the frameworks and controls out there won't easily let you but if you can, do. |
 |
|
|
|
|
|
Order By Union