Thank you for the concern.

The ERD and the View columns in the image are exactly what they need to be to illustrate the starting point and desired result (and...

Many thanks to everyone who responded!

Vilyana

Sergiy (9/19/2016)

---

It seems the design is faulty.

PatientMedicationCourse must be allocated to PatientTherapyCourse, not directly to PatientTreatment.

Medications prescribed for one Therapy Course must not be mixed with medications for another one.

Relying...

frederico_fonseca (9/19/2016)

---

Hum..

just for record I have given vilyana a working bit of code prior to the posting of the code above which I can't download at all as it gives...

Hi, I've attached the DDL, sample data, the View ad a code snippet.

frederico_fonseca (9/17/2016)

---

complex - and a few answers required.

your code only contemplates 2 treatments and 2 courses - what if there are 5 or 10 treatments? or if there are more...

Rod, yes. Increasing to varchar(max), or to anything higher than the current VARCHAR (100), shouldn't affect your data...unlike attempting to reduce to lower than your longest string in the column...

Thank you for responding! I will do more research on that. I think this could probably be done via SSIS as well. Another thing I found while going through the...

This is a shortcut, but why not create a copy of the database and truncate all non-reference tables?

I think the solution could be as 'simple' as having a copy of the same Meta DB on each server which would enable the application to obtain the correct connection...

I think the solution could be as 'simple' as having a copy of the same Meta DB on each server which would enable the application to obtain the correct connection...

Lutz,

Luckily nothing RBAR in this process ... I think in sets most of the time 🙂

Failure doesn't happen often - it's just a lot of data, lots of tables, kicks...

Hi Lutz,

Thanks for the detailed reply!

This is definitely one way to control SP rerun and whether the queue gets cleaned up. And I completely agree about having any issues...