title: Order By not working on datetime 101 format
body: <pre><code>Create table #temp
  (
  OrderDate datetime
  )
  
  insert into #temp values ('01/21/2015'),('01/20/2014'),('11/12/2013')
  
  select distinct convert(varchar(10),orderdate,101) as OrderDate  from #temp 
  order by convert(varchar(10),orderdate,101) asc
  </code></pre>
  
  <p>The above query gives me the result like below:</p>
  
  <pre><code>OrderDate
  01/20/2014
  01/21/2015
  11/12/2013
  </code></pre>
  
  <p>But I want the result like below: </p>
  
  <pre><code>OrderDate
  11/12/2013
  01/20/2014
  01/21/2015
  </code></pre>
  
  <p>The above is just a sample on which I am trying to do sorting on format <strong>101</strong>. In my actual query I need to use <strong>distinct</strong> keyword and also the columns will come dynamically in the select statement by using parameter.</p>
  
  <p>I can't use group by in my actual query.</p>
  
  <p>Please help.</p>