Excellent article, well written and an easy read. I need to look at/play around with your code a little more to understand what you're doing but I love the overall...

EdgeOfKnowWare (2/22/2016)

---

Alan, I agree with you, if you're just wanting one ranking. If we expand upon the Original Posters issue (which is what I was facing) and say that you...

jim.snyder (2/22/2016)

---

Thanks, Alan. This is hospital data and I am bound by HIPAA and PMI to not give account numbers or personal information out. I understand (went to the link...

EdgeOfKnowWare (2/22/2016)

---

No, that's not quite what I was trying to do.

The problem I had (which lead me to this post via Google) was that I had several different rankings dependent...

Glad to help.

Me too. So much so that I now have a receding hairline :hehe:

Phil Parkin (2/22/2016)

---

Alan.B (2/22/2016)

---

Ed Wagner (2/22/2016)

---

Luis Cazares (2/19/2016)

---

Ed Wagner (2/19/2016)

---

GilaMonster (2/19/2016)

---

SQLRNNR (2/18/2016)

---

I am seeing people claim to be an MCM for some of these interviews. I know full well they...

jim.snyder (2/22/2016)

---

I am building a process where I have a few places that have multiple rows with the same (non-unique) key. In one area, I can use the field that...

EdgeOfKnowWare (2/22/2016)

---

Maybe a work around would be something like this:

SELECT *,

CASE WHEN val IS NULL THEN 0 ELSE 1 END,

NTILE(4) OVER (PARTITION BY CASE WHEN val IS NULL THEN 0...

If you are using multi-select in SSRS then SSRS is passing a comma-delimited string to your query or stored proc....

Ed Wagner (2/22/2016)

---

Luis Cazares (2/19/2016)

---

Ed Wagner (2/19/2016)

---

GilaMonster (2/19/2016)

---

SQLRNNR (2/18/2016)

---

I am seeing people claim to be an MCM for some of these interviews. I know full well they aren't an MCM....

Jacob Wilkins (2/22/2016)

---

Alan.B (2/22/2016)

---

Jacob Wilkins (2/19/2016)

---

kkilsby (2/19/2016)

---

Doesn't the SQL DB engine first create a cross join for any query involving more than one table? So performance isn't an issue for...

Jacob Wilkins (2/19/2016)

---

kkilsby (2/19/2016)

---

Doesn't the SQL DB engine first create a cross join for any query involving more than one table? So performance isn't an issue for a cross join...

What does that accomplish?

How many of you have gotten up before dawn, driven to the coast, gotten on a long piece of fiberglass and paddled into the ocean before turning around to ride...

Jacob Wilkins (2/17/2016)

---

Alan.B (2/17/2016)

---

Perhaps... To know for sure check the query plan (the actual...