<div>
Had to do a little tweaking to code, but you got me in the right directions. Thanks!!
</div>


Had to do a little tweaking to code, but you got me in the right directions. Thanks!!

<div>
You might also look into my solution of a similar problem at <a href="https://www.experts-exchange.com/questions/28963238/SQL-sum-months-quarter-YTD.html?anchorAnswerId=41756192#a41756192" rel="ugc">https://www.experts-exchange.com/questions/28963238/SQL-sum-months-quarter-YTD.html?anchorAnswerId=41756192#a41756192</a><br />
<br />
Bye, Olaf
</div>


You might also look into my solution of a similar problem at https://www.experts-exchange.com/questions/28963238/SQL-sum-months-quarter-YTD.html?anchorAnswerId=41756192#a41756192 [https://www.experts-exchange.com/questions/28963238/SQL-sum-months-quarter-YTD.html?anchorAnswerId=41756192#a41756192]

Bye, Olaf

<div>
<div class="content wysiwyg-content">
I am trying to create a query\procedure that will show the total number of orders from a selected customer in 6 month intervals. For 6, 12, 18 and 24 months. Please show a step by step.<br />
<br />
example if abc company order 6 times from Jan to Jun and 4 times from Jul-Dec then i want the report to show<br />
<br />
company &nbsp; &nbsp;6_Months &nbsp; &nbsp;12_Months<br />
acbc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10 &lt;----- Rolling sum<br />
<br />
I am using microsoft sql server 14
</div>
</div>


I am trying to create a query\procedure that will show the total number of orders from a selected customer in 6 month intervals. For 6, 12, 18 and 24 months. Please show a step by step.

example if abc company order 6 times from Jan to Jun and 4 times from Jul-Dec then i want the report to show

company    6_Months    12_Months
acbc                   6                  10 <----- Rolling sum

I am using microsoft sql server 14

count number of orders in 6 month intervals

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.