System databases Isolation

RE: Insert From Query failure

Yes, the not exists criteria within the query seems to work.  Don't know why I didn't consider doing that...thanks guys!

RE: Help with UPDATE query

Thanks for the reply. I had tried replacing the OR with an AND, and I still get the same results. IF EXISTS(SELECT F00069, F00026, F01298, F01299, F01300 FROM patient INNER JOIN tumor ON patient.UK = tumor.FK1 INNER JOIN followup ON tumor.FK1 = followup.FK1 INNER JOIN hospital ON tumor.UK = hospital.FK2 WHERE (hospital.F00026 = '0' OR […]