<div>
Hi ste5an,<br />
<br />
Thank you fo your post.<br />
But that does what i already know, like i said in the post.. you're calculating the total days, hours and mins in each row.<br />
<br />
What i need is to have a final sum of all rows.
</div>


Hi ste5an,

Thank you fo your post.
But that does what i already know, like i said in the post.. you're calculating the total days, hours and mins in each row.

What i need is to have a final sum of all rows.

<div>
The math for the total is the same as for the row. Thus the running sum sample..
</div>


The math for the total is the same as for the row. Thus the running sum sample..

<div>
I realized that later.. but in the mean while BriCrowe gave the all answer.<br />
Thx friend.
</div>


I realized that later.. but in the mean while BriCrowe gave the all answer.
Thx friend.

<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
I have a table with two columns, the initial date and the final date.<br />
I know how calculate days hours and minutes between them with datediff.<br />
<br />
But i need to calculate the total days, hours and minutes of all rows in the end.<br />
<br />
inidate &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; enddate &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; result<br />
01/01/2014 01:30 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02/01/2014 03:00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1d 1h 30m<br />
03/01/2014 01:30 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;05/01/2014 03:00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2d 1h 30m<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total: 2d 3h 00m<br />
<br />
Anyone know a easy way to do this?<br />
<br />
Thx in advanced,<br />
Miguel
</div>
</div>


Hello experts,

I have a table with two columns, the initial date and the final date.
I know how calculate days hours and minutes between them with datediff.

But i need to calculate the total days, hours and minutes of all rows in the end.

inidate	                enddate	                result
01/01/2014 01:30	02/01/2014 03:00	1d 1h 30m
03/01/2014 01:30	05/01/2014 03:00	2d 1h 30m
		
		Total: 2d 3h 00m

Anyone know a easy way to do this?

Thx in advanced,
Miguel

Total days hours and minutes

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

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.