<div>
So, count of all StatusAs for today, count of all from yesterday, etc?
</div>


So, count of all StatusAs for today, count of all from yesterday, etc?

<div>
That works a treat, just a quick question before I close it off, if I wanted to use a different date field for 2 different statuses is this possible? From what I know I would have to create 2 different views with the different date field but just thought I would throw it out there.<br />
<br />
For example 2 status &nbsp;&quot;Sent Out&quot; and &quot;Returned&quot; &nbsp;with 2 dates &quot;date Sent Out&quot; and &quot;Date Returned&quot;
</div>


That works a treat, just a quick question before I close it off, if I wanted to use a different date field for 2 different statuses is this possible? From what I know I would have to create 2 different views with the different date field but just thought I would throw it out there.

For example 2 status  "Sent Out" and "Returned"  with 2 dates "date Sent Out" and "Date Returned"

<div>
Sounds to me that that approach could be extended to additional date columns...
</div>


Sounds to me that that approach could be extended to additional date columns...

<div>
<div class="content wysiwyg-content">
I have data that has 2 columns, a status and a date.<br />
<br />
is it possible to build the following report in SQL and if so how would I do it<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Today &nbsp; &nbsp; &nbsp; &nbsp; Yesterday &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Week &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Month<br />
StatusA<br />
StatusB<br />
<br />
So I would want a total sent today from statusA and B then yesterdays everything this week and finally everything this month (last 7 and 30 days)
</div>
</div>


I have data that has 2 columns, a status and a date.

is it possible to build the following report in SQL and if so how would I do it

                  Today         Yesterday           Week             Month
StatusA
StatusB

So I would want a total sent today from statusA and B then yesterdays everything this week and finally everything this month (last 7 and 30 days)

SQL Pivot Table

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.