Lynn Pettis (7/28/2014)

---

dwain.c (7/28/2014)

---

Easy for you to say. I assume you...

Easy for you to say. I assume you have hair.

Lynn Pettis (7/28/2014)

---

The Dixie Flatline (7/28/2014)

---

I respect and admire all you guys for your professionalism, and often restraint, in dealing with all manner of questions. Steve does...

Jeff Moden (7/28/2014)

---

It's funny... I didn't even see that I had responded to a 2 year old post.

Whether or not rCTEs are the right tool for a given problem...

Thanks to all the recent responders. This article was first published a few years back and its main value I think is that it explores some non-traditional cases.

I have...

Jeztagab (7/21/2014)

---

the data below is an example the Patient with memberid = 1 has been admitted and discharge from the hospital 2x for year 2013. all the other dates are...

Some further advice to get you a quicker answer:

1. Provide DDL (CREATE TABLE) and consumable sample data. That way you're more likely to get a working query as a...

Jeztagab (7/18/2014)

---

Please help how to solve the problem below using recursion..

My problem here is how to identify and select a patients service date. A service date could be admission date(hospital),...

Absolutely!

Jeff Moden (6/30/2014)

---

tafinami (6/30/2014)

---

DECLARE c CURSOR READ_ONLY FAST_FORWARD FOR

SELECT Id FROM Tree_Table WHERE Id NOT IN (SELECT DISTINCT ParentId FROM Tree_Table WHERE ParentId IS NOT NULL)

DECLARE @IdPk INT

OPEN...

Jeff Moden (6/28/2014)

---

Apologies for the VERY...

Jeff Moden (6/25/2014)

---

dwain.c (6/25/2014)

---

Even though I haven't had much time of late to devote to SQL stuff, I did find time to go back and re-read this article.

Excellent...

Even though I haven't had much time of late to devote to SQL stuff, I did find time to go back and re-read this article.

Excellent new information in...

That picture predates my catch of the...

Answer No to the one about TFS. Unless it's a recipe for alphabet soup.