title: Can we get day number by passing day name?
body: <p>Is it possible to get a day number of the week from day name in sql server without hard coding? 
  Some thing like this</p>
  
  <pre><code>select DatePart(xx, 'Monday') 
  result: 1
  </code></pre>