ChrisM@Work (1/14/2016)

---

wolfgheist (1/14/2016)

---

ChrisM@Work (1/14/2016)

---

wolfgheist (1/14/2016)

---

I am playing around with it, but it keeps pulling too much data. It is pulling 20k+ rows, when my first script above pulls 4302 rows...

This script appears to be doing exactly what I want. Thanks both of you guys. You are awesome!!! 🙂

[Code="sql']SELECT

MedicalRecordNumber, AccountNumber, FirstName, LastName, WhenDischarged, d.cnt

FROM (

SELECT *,

last_discharge = MAX(ISNULL(p.WhenDischarged,...

drew.allen (1/14/2016)

---

ROW_NUMBER() is overused. Here the OP needs a single value from one record to be available across the entire partition, namely whether a NULL exists on any record...

ChrisM@Work (1/14/2016)

---

wolfgheist (1/14/2016)

---

I am playing around with it, but it keeps pulling too much data. It is pulling 20k+ rows, when my first script above pulls 4302 rows that contains...

How are you creating the little window with correct spacing format? Here are the results that I am seeing from your last query.

MRN FIN...

I am playing around with it, but it keeps pulling too much data. It is pulling 20k+ rows, when my first script above pulls 4302 rows that contains all of...

Sorry for the poor format of the results. I cannot figure out how to get this site to use the spacing I typed out.

Hi Chris,

Thanks for the suggestion, but I cannot get that to show what I need.

It is Pulling

MedicalRecordNumberAccountNumberFirstNameLastNameWhenDischarged

12345 ...