<div>
&gt;CAST((SUM(ACD.talkTime)/C<wbr />OUNT(ACD.S<wbr />tartDateTi<wbr />me)%60) <br />
Also looks like the parentheses marks are not correct, perhaps this should be..
<pre><code id="code-20-39480221-1">RIGHT('00'+ CAST((SUM(ACD.talkTime)/COUNT(ACD.StartDateTime)) %60 AS VARCHAR(2)),2) AS [Avg_Talk_Time] </code></pre>
</div>


>CAST((SUM(ACD.talkTime)/COUNT(ACD.StartDateTime)%60)
Also looks like the parentheses marks are not correct, perhaps this should be..

RIGHT('00'+ CAST((SUM(ACD.talkTime)/COUNT(ACD.StartDateTime)) %60 AS VARCHAR(2)),2) AS [Avg_Talk_Time] 

<div>
Yes the %b acts like a MOD giving the remander. &nbsp;I did not know it did this with TIME values but i guess it does. &nbsp; Thanks
</div>


Yes the %b acts like a MOD giving the remander.  I did not know it did this with TIME values but i guess it does.   Thanks

<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the grade.  Good luck with your project.  -Jim

<div>
&gt;&gt; <i>did not know it did this with TIME values</i><br />
it isn't dealing with time units directly, in this case it is: &nbsp;sum()/count() then modulus of 60<br />
<br />
SUM(ACD.talkTime)/COUNT(AC<wbr />D.StartDat<wbr />eTime) % 60<br />
<br />
tip: modulus of 7 when working with days of week is excellent, e.g.<br />
<br />
SELECT datediff(DAY,0,getdate()) % 7 -- 0 is Monday (regardless of sqlserver settings)
</div>


>> did not know it did this with TIME values
it isn't dealing with time units directly, in this case it is:  sum()/count() then modulus of 60

SUM(ACD.talkTime)/COUNT(ACD.StartDateTime) % 60

tip: modulus of 7 when working with days of week is excellent, e.g.

SELECT datediff(DAY,0,getdate()) % 7 -- 0 is Monday (regardless of sqlserver settings)

<div>
<div class="content wysiwyg-content">
What does this SQL statement do and how does the % sign work<br />
I am trying to get an averrage time per call and this is what I came across in the &nbsp;exsisting code.<br />
<br />
&nbsp; ,RIGHT('00'+CAST((SUM(ACD.<wbr />talkTime)/<wbr />COUNT(ACD.<wbr />StartDateT<wbr />ime)%60) AS VARCHAR),2) AS [Avg_Talk_Time]
</div>
</div>


What does this SQL statement do and how does the % sign work
I am trying to get an averrage time per call and this is what I came across in the  exsisting code.

  ,RIGHT('00'+CAST((SUM(ACD.talkTime)/COUNT(ACD.StartDateTime)%60) AS VARCHAR),2) AS [Avg_Talk_Time]

What does this percent sign do ?

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 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.

Microsoft SQL Server

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.