Beginning a New Year.

Well, Kassondra is on her way back to AIT in a "new" car. She left our house about 7:30 to pick-up another soldier heading back as...

Exhausted

Okay, if you can see the Peak, where do you call home?

To the denizens of The Thread, regulars and lurkers alike, as we bid a fair farewell to 2009 may we all have a Joyous and Prosperous New Year and may...

Jack Corbett (12/29/2009)

---

Lynn,

Sorry to hear about the accident and injury. Glad that they are not serious. Sounds like Kassondra should stay out of vehicles around holidays. Wasn't...

Wasn't the result of ice/snow. She got t-boned in a construction area. Dark, no traffic light, view severly hampered by signs and concrete k-bars. She thought she...

WayneS (12/29/2009)

---

Lynn Pettis (12/29/2009)

---

Congrats Gus. How about sending some of that good luck my way. Can't seem to catch a break at all.

Kassondra was in a car accident...

Congrats Gus. How about sending some of that good luck my way. Can't seem to catch a break at all.

Kassondra was in a car accident Sunday night (car...

Not what I asked. I asked if you understood the logic in MY code. If you need to modify it for additional requirements (new demographic requirements to be...

Atif Sheikh (12/28/2009)

---

THANKS ALOT Lynn Pettis...

The solution is working perfectly, also with the new patient scenarios. I will check it with a few more patient scenarios and will upload it...

Ulises Telcontar (12/25/2009)

---

MAXRECURSION cannot be used on UDFs. This is limited by the default MAXRECURSION value of 100 as it was mentioned above.

The WHILE methods are not the best performers...

Well, since you thought the code was long, and having gotten some sleep after solving this particular SQL logic problem, here is a rewrite of the code I had posted...

Gkhadka (12/22/2009)

---

CriquedeSQL... I think you missunderstood the question above. I think he is saying that he installed SQL 2008 and SSIS on one server (let it be a DEV box)....

First, I'm glad this is a SQL Server 2005 forum. Here is a possible solution, but how you implement it is all up to you since you haven't provided...

Not a problem posting your code. It actually is different than was suggested before. It is always good to post your final solution. Others may benefit, so...