<div>
can you explain a bit in detail what exactly you have the problem with?<br />
1 important detail: what data type is the field date_entered, and is it containing a time portion?
</div>


can you explain a bit in detail what exactly you have the problem with?
1 important detail: what data type is the field date_entered, and is it containing a time portion?

<div>
twintai -- &nbsp;I liked yours the best but found these options where more appropriate for sql server<br />
<br />
<a href="http://support.microsoft.com/kb/186265" rel="ugc nofollow">http://support.microsoft.com/kb/186265</a><br />
<br />
&nbsp; &nbsp;Ms &nbsp; &nbsp;for Milliseconds<br />
&nbsp; &nbsp;Yy &nbsp; &nbsp;for Year<br />
&nbsp; &nbsp;Qq &nbsp; &nbsp;for Quarter of the Year<br />
&nbsp; &nbsp;Mm &nbsp; &nbsp;for Month<br />
&nbsp; &nbsp;Dy &nbsp; &nbsp;for the Day of the Year<br />
&nbsp; &nbsp;Dd &nbsp; &nbsp;for Day of the Month<br />
&nbsp; &nbsp;Wk &nbsp; &nbsp;for Week<br />
&nbsp; &nbsp;Dw &nbsp; &nbsp;for the Day of the Week<br />
&nbsp; &nbsp;Hh &nbsp; &nbsp;for Hour<br />
&nbsp; &nbsp;Mi &nbsp; &nbsp;for Minute<br />
&nbsp; &nbsp;Ss &nbsp; &nbsp;for Second<br />

</div>


twintai --  I liked yours the best but found these options where more appropriate for sql server

http://support.microsoft.com/kb/186265 [http://support.microsoft.com/kb/186265]

   Ms    for Milliseconds
   Yy    for Year
   Qq    for Quarter of the Year
   Mm    for Month
   Dy    for the Day of the Year
   Dd    for Day of the Month
   Wk    for Week
   Dw    for the Day of the Week
   Hh    for Hour
   Mi    for Minute
   Ss    for Second


<div>
<div class="content wysiwyg-content">
I'm working on a chart and would like to select the sum of orders on any certain day, month or by a year.<br />
<br />
select sum(orders), date_entered from orders where date_entered = getDate() - 365<br />
group by date_entered
</div>
</div>


I'm working on a chart and would like to select the sum of orders on any certain day, month or by a year.

select sum(orders), date_entered from orders where date_entered = getDate() - 365
group by date_entered

Select Sum by Day, Month or Year

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.