Looks like a pretty efficient technique. Thanks for the added value.

But you do need to be careful about one thing though:

Msg 535, Level 16, State 0, Line 5

The datediff...

lkent (9/26/2013)

---

In the healthcare industry, length of stay (LOS) is always fun figuring out how to present the data.

Usually we only count days stay with a default of 1. ...