syntax:

ROW_NUMBER ( )

OVER ( [ PARTITION BY value_expression , ... [ n ] ] order_by_clause )

Thank you Sir, I have some learning to do.:-)

I am thankful for this site and others that guide my never-ending quest for the next solution.

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