<div>
<div class="content wysiwyg-content">
Hi..<br />
I have a Sales table with dates (Sale_Date).<br />
I also have a table of Qtrs &nbsp;(1st,2nd,3rd,4th) - Business Qtrs<br />
<br />
The table of Qtrs looks something like this<br />
<br />
START &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;END<br />
1/1/2015 &nbsp; &nbsp; &nbsp; &nbsp;3/31/2015 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1ST<br />
4/1/2015 &nbsp; &nbsp; &nbsp; &nbsp;6/30/2015 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2ND<br />
....<br />
<br />
How can I group and sum my Sales data by QTR? &nbsp; &nbsp; Sales date must fall in the Qtr date range.<br />
<br />
thx
</div>
</div>


Hi..
I have a Sales table with dates (Sale_Date).
I also have a table of Qtrs  (1st,2nd,3rd,4th) - Business Qtrs

The table of Qtrs looks something like this

START            END
1/1/2015        3/31/2015          1ST
4/1/2015        6/30/2015          2ND
....

How can I group and sum my Sales data by QTR?     Sales date must fall in the Qtr date range.

thx

Group by date ranges

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.