title: order by descending date is not working?
body: <pre><code>SELECT convert(VARCHAR, WH.DATE, 103),
      PN.partyname,
      BT.birdname,
      dt.totalweight,
      dt.rateperkg,
      dt.dcno,
      mr.branch
  FROM K_RT_Dailyentryretail DT
  INNER JOIN K_RT_PartyName PN
      ON pn.sno = dt.partyname
  INNER JOIN K_RT_WarehouseDetails WH
      ON dt.branchdate = wh.sno
  INNER JOIN K_RT_BirdType BT
      ON dt.birdtype = bt.sno
  INNER JOIN K_RT_MasterRetailStores MR
      ON MR.sno = WH.branch
  WHERE MR.branch + ' - ' + convert(VARCHAR, WH.DATE, 103) = @date
  ORDER BY convert(VARCHAR, WH.DATE, 103) DESC
  </code></pre>
  
  <p>here..order by date is not working.  How can I fix this?</p>