Used row ids to uniquely tag the transactions and a couple of CTEs to compute the running balances. Added a union at the end to select the first transactions.

Used row ids to uniquely tag the transactions and a couple of CTEs to compute the running balances. Added a union at the end to select the first transactions.

Thank you!

I used CTE's isolate the admission dates that had no discharge on the previous day and discharge dates that had no admission on the following day. By using the Row_number function on bothe, I was able to join the result tables into another giving the 'isla

I used CTE's isolate the admission dates that had no discharge on the previous day and discharge dates that had no admission on the following day. By using the Row_number function on bothe, I was able to join the result tables into another giving the 'isla