<div>
AngelIII - Thank you.., but am looking for per day per team percentage.., sorry if my question was confusing.
</div>


AngelIII - Thank you.., but am looking for per day per team percentage.., sorry if my question was confusing.

<div>
Perfect. I made the changes with dates. Thanks again for your help
</div>


Perfect. I made the changes with dates. Thanks again for your help

<div>
<div class="content wysiwyg-content">
Team,<br />
<br />
Need your help.<br />
<br />
I have a table with some data on it. Please find attached a sample look of the table.<br />
<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/03_w12/429820/EE.JPG" target="_blank" title="Sample File (22 KB)"><img alt="Sample File" class="file-block lazyload" style="max-width: 493px;" data-src="https://filedb.experts-exchange.com/incoming/2011/03_w12/429820/EE.JPG" /></a><br />
What i really want to do is, % &nbsp;of escalated cases by team.<br />
<br />
Escalation % per team = &nbsp;Number of Escalations for the day / Number of cases handled for the day.<br />
<br />
I cannot run pivot queries in my SQL as it doesnt support.<br />
<br />
requesting your help to find the desired result in a query.<br />
<br />
Thanks,<br />
David
</div>
</div>


EE.JPG

Team,

Need your help.

I have a table with some data on it. Please find attached a sample look of the table.

 

What i really want to do is, %  of escalated cases by team.

Escalation % per team =  Number of Escalations for the day / Number of cases handled for the day.

I cannot run pivot queries in my SQL as it doesnt support.

requesting your help to find the desired result in a query.

Thanks,
David

SQL Query Help - Something like Pivot

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.

Microsoft SQL Server 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

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.