Just realized what you meant by the white space issue. The unformatted lines might have more than one space between the number and the word "Admission(s)" or "Discharge(s)"....

You're welcome, Quentin.

I apologize for not posting a link to delimitedsplit8k. It is a tool which should be in everyone's toolkit. ...

Just did some quick reading. Didn't find a LAG solution, but windowed functions are awesome for this.

In the OPs problem at hand, we need something other than ID...

Hey Jeff. I've never done that, but then I don't usually have to do running totals in SQL. Going to go read up on that...

WARNING WARNING WARNING: You MUST get your inputs standardized. You are at risk until then.

That said. This was a fun problem, and the...

Fine with me. Here is some reading for anyone else who wanders along.

Solving the Running Total and Ordinal Rank Problems (Rewritten) by Jeff Moden

(I'm oddly unable to...

What column(s) are you using for your Full Outer Join?

Given the sample data below, it seems obvious that the join should be on the [Eno] column.

A join on...

Hey JL: You have two groups of IDs. What result are you expecting?

This is a variation on the running totals problem.

The logic is that 100 is subtracted from the first value, 50 is subtracted from the second value, and 25 from the...

Withdrawn for unforgivably not seeing Luis' answer and writing the same thing myself. :w00t:

TomThomson (6/24/2016)

---

Ed Wagner (6/22/2016)

---

jasona.work (6/22/2016)

---

TomThomson (6/22/2016)

---

jasona.work (6/22/2016)

---

/me leans back, marveling at what happens when you toss a crystal into a supersaturated solution...

Sounds like the next couple weeks / months are...

I would also like to apply for citizenship to the island.

Be sure it has coconut palms. I think the Professor on Gilligan's Island had...

I'm not sure I can beat that one for redundundundancy, but I'm reading through a client app written in COBOL that apparently does a call to the database to get...

Without using specific examples to test, it is hard to explain why set-based processing outperforms cursor-based code. Logging certainly plays a part as does the frequency of posting...

You've got it right that partition switching doesn't physically move the partitioned data. It simply changes pointers that define which table the partitioned data is owned by. ...