<div>
You could try something like this: (not exactly what you were asking for)<br />
<br />
select ID, Hours, Date, DATEPART(wk, Date) WeekNumber <br />
from ....<br />
<br />
or if you were summarizing by week, you could put<br />
<br />
select sum(Hours) TotalHours, DATEPART(wk, Date) WeekNumber <br />
from ....<br />
group by DATEPART(wk, Date)<br />

</div>


You could try something like this: (not exactly what you were asking for)

select ID, Hours, Date, DATEPART(wk, Date) WeekNumber
from ....

or if you were summarizing by week, you could put

select sum(Hours) TotalHours, DATEPART(wk, Date) WeekNumber
from ....
group by DATEPART(wk, Date)


weeks.png

<div>
Awesome. &nbsp;This is exactly what I was trying to get at and use the week as a grouping.
</div>


Awesome.  This is exactly what I was trying to get at and use the week as a grouping.

<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
I need to group some data base of dates. &nbsp;It needs to be grouped base on a weekly date. &nbsp;See example.<br />
<br />
Raw data:<br />
ID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HOURS &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DATE<br />
8922 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8/30/2010<br />
8923 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;09.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8/31/2010<br />
8924 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;08.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9/2/2010<br />
8930 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;09.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9/2/2010<br />
8941 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;04.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9/6/2010<br />
8942 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;09.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9/8/2010<br />
8945 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;03.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9/10/2010<br />
<br />
Need to group it like the following:<br />
<br />
ID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HOURS &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DATE<br />
8/30 - 9/3<br />
8922 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8/30/2010<br />
8923 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;09.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8/31/2010<br />
8924 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;08.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9/2/2010<br />
8930 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;09.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9/2/2010<br />
9/6 - 9/10<br />
8941 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;04.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9/6/2010<br />
8942 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;09.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9/8/2010<br />
8945 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;03.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9/10/2010
</div>
</div>


Hello experts,

I need to group some data base of dates.  It needs to be grouped base on a weekly date.  See example.

Raw data:
ID	HOURS	DATE
8922	10.00	8/30/2010
8923	09.00	8/31/2010
8924	08.00	9/2/2010
8930	09.00	9/2/2010
8941	04.00	9/6/2010
8942	09.00	9/8/2010
8945	03.00	9/10/2010

Need to group it like the following:

ID	HOURS	DATE
8/30 - 9/3
8922	10.00	8/30/2010
8923	09.00	8/31/2010
8924	08.00	9/2/2010
8930	09.00	9/2/2010
9/6 - 9/10
8941	04.00	9/6/2010
8942	09.00	9/8/2010
8945	03.00	9/10/2010

SQL Query - Grouping by weekly

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.