Agree I do, with Jack.

Please provide the table structure, sample data, expected results, and what you have done so far to solver your problem.

Fully agree, one file per full, differential, and transaction log backups.

Something like this is what you may be needing. Need to know how the list of report id's is being passed back to the database, is it a comma...

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...