title: FIND previous businessday this code is too slow
body: <p>My code to find prior business day (only date, without time part) takes 1 minute to execute which is too long. Please help to find an alternative. It is a stored procedure which takes value from diff tables in which I take currentdate to get previous day data (exclude weekends).</p>
  
  <p>Code:</p>
  
  <pre><code>convert(varchar(10), utilization_date, 111) = dateadd(day, 
                          CASE WHEN datepart(day, getdate()) = 1 THEN -2 
                               WHEN datepart(day, getdate()) = 2 THEN -3 
                               ELSE -1
                          END, 
                          convert(varchar(10), getdate(), 111))  
  </code></pre>