<div>
what do you mean by pending tasks?
</div>


<div>
Yes, <br />
&nbsp;I want to accomplish the something like I have showed in Code Snippet.<br />
<br />

<pre><code class="code-1 nolinks" id="code-264722"><span>Sun	Mon	Tue	Wed	Thu	Fri	Sat`</span>
<span>Task1		Task2	Task3		Task5	</span>
<span>	Task8		Task7	Task11		</span>
<span>	Task20	Task15				</span>
<span>						</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
Hi experts,<br />
&nbsp; I need a sql query that will list all the pending tasks day wise for the current week. I am using SQL Server 2005.<br />
<br />
Please Help me.<br />
<br />
Thanx In Advance.<br />

</div>
</div>


Hi experts,
  I need a sql query that will list all the pending tasks day wise for the current week. I am using SQL Server 2005.

Please Help me.

Thanx In Advance.


sql query for listing daywise tasks of current week

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.