• The view will order correctly if you use 'Select top 100000000000' or whatever number of records that you are sure to return all.