title: SQL Server compound query
body: <p>Hello and thanks for looking.</p>
  
  <p>I wrote a simple application for my softball team and I am having some issues with the query I need to rewrite.</p>
  
  <pre><code>SELECT DISTINCT 
      _StartDate, _RescheduleDate, _GameTime, _FieldNumber, _Notes
  FROM
      _Schedule
  WHERE
      (_StartDate &gt;= DATEADD(wk, 0, { fn NOW() })) 
      AND (_StartDate &lt; DATEADD(wk, 1, { fn NOW() }))
  </code></pre>
  
  <p>This query simply gets the upcoming weeks game schedule. What I need to do and I had forgotten, was to check also for <code>_RescheduleDates</code> we currently have 1 or 2 games that are rescheduled.  So somehow I need to modify this to check if reschedule date has a valid date and not "TBD" or NULL.</p>
  
  <p>The second problem is, our games are on Friday, on the day of the game, this changes the data on the website to next weeks game and I need it to not change until the day after the game which is Saturdays. I tried adding 1 day</p>
  
  <pre><code>(wk, 1 +1d {fn NOW() })) 
  </code></pre>
  
  <p>But obviously this did not work. So I would surely appreciate some help with that.</p>