dcowdery (1/16/2014)

---

I ran into this in the last job...

Calculate the duration between start datetime and end datetime for KPI reporting, factor in:

- Business Days only (no holidays)

- Business...

Dennis Wagner-347763 (1/16/2014)

Thomas, I like the way you are thinking. My solution was to build a function that would use the elapsed days to do the formatting.

While...

I meant to post this earlier, but got caught up in some of the tangent. Thanks to Jeff for providing this spackle. Great job, as always.

Dennis Wagner-347763 (1/16/2014)

---

The issue with doing simple DATEDIFF in SQL is that it does a straight subtraction. From the example above:

DATEDIFF(year, '10/16/95', '1/15/14') = 19 (but only 18...

Eirikur Eiriksson (1/16/2014)

---

Thank you for the spackle Jeff but it looks like there is a small crack in it as it makes the assumption that the end time is always...

But that only displays the fractional hours portion of...

Dennis Wagner-347763 (1/16/2014)

---

Do you have a good query for formatting duration (or age) in Years, Months, Days?

So often in my world, I am asked to find out who...

Stephanie J Brown (1/15/2014)

---

The same can be said about our profession. Some people will be craftsman level, some will "build it with jigs", and some will "just get by"....

So easy I thought it was Monday. Thanks!

And, yes, it was a bit ambiguous. But, unlike the question I cried foul on earlier this week, you didn't have to mind...

Excellent Carlo! Thanks for a great question.

We're just not, we're not craftspeople, at least not most of us. We do what we need to do at work. We get systems working just enough. We get by....

Thank you Steve!

Steve Jones - SSC Editor (1/14/2014)

There's a strategy, but it isn't backup and restore as we know it with SQL Server. You cannot run a BACKUP DATABASE command or a...

Big +1. I found many refs...

Another "easy" question that still managed to teach us something. Thanks Steve!