title: Get Current week days from monday to sunday
body: <p>I have tried solution for this is like.</p>
  
  <pre><code>select dateadd(wk, datediff(wk, 0, getdate()), 0)as StartDate ,
     (select dateadd(wk, datediff(wk, 0, getdate()), 0) + 5) as EndDate
  </code></pre>
  
  <p>it gives monday-saturday in result, but on Sunday it gives me next week days</p>
  
  <p>I want sunday as last day of week and Monday as First Day of week..</p>
  
  <p>Please Help...</p>