I'm testing these scenarios and seeing no difference between any of the queries. Even the last query in the article that uses two equal comparisons instead of a between, all have 66 logical reads. Personally, I would have gone with the solution that g...

I'm testing these scenarios and seeing no difference between any of the queries. Even the last query in the article that uses two equal comparisons instead of a between, all have 66 logical reads. Personally, I would have gone with the solution that g...

Hello... I've been tasked with creating a packaged report based on charts that are available on my companies website (http://www.realtytrac.com/trendcenter/). The requester does not want any difference between the packaged report and the site. Links suc...

Hello... I've been tasked with creating a packaged report based on charts that are available on my companies website (http://www.realtytrac.com/trendcenter/). The requester does not want any difference between the packaged report and the site. Links ...

<p>reformatted script...</p> <p> </p> <pre class="brush:sql">DECLARE @Days INT, @KeepIt SMALLDATETIME <br /> SET @Days = 45 <br /> DECLARE @Staging TABLE (SaleID INT, SaleDate SMALLDATETIME) <br /> DECLARE @Staging2 TABLE (SaleID INT, SaleD...

<p>Good morning,</p> <p>I have a task where I am given a single property, and I need to return sales records.  The sales records need to be unique within a 45 days period starting from the first record of sale to the most recent.  I have a solut...

Good morning, I have a task where I am given a single property, and I need to return sales records. The sales records need to be unique within a 45 days period starting from the first record of sale to the most recent. I have a solution that uses a l...