NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
length(trim(accident.accident_localid)) = 0 OR
length(trim(accidentinfoversion.accident_localid)) = 0) AND
accidentinfoversion.link_only = '0f'
ORDER BY
accident.accident_localid ASC
Inner Join hazard ON hazardinfoversion.hazard_guid = hazard.hazard_guid
WHERE
hazardinfoversion.link_only = '0f' AND
(hazardinfoversion.hazard_localid IS NULL OR
hazard.hazard_localid IS NULL OR
length(trim(hazreducinfoversion.hazreduc_localid)) = 0 OR
length(trim(hazreduc.hazreduc_localid)) = 0 ) AND
hazreducinfoversion.link_only = '0f'
ORDER BY
hazreduc.hazreduc_localid ASC
length(trim(locationinfoversion.location_localid)) = 0 OR
length(trim(location.location_localid)) = 0) AND
locationinfoversion.link_only = '0f'
ORDER BY
location.location_localid ASC
length(trim(mreinfoversion.mre_localid)) = 0 OR
length(trim(mre.mre_localid)) = 0) AND
mreinfoversion.link_only = '0f'
ORDER BY
mre.mre_localid ASC
length(trim(qainfoversion.qa_localid)) = 0 OR
length(trim(qa.qa_localid))= 0) AND
qainfoversion.link_only = '0f'
ORDER BY
qa.qa_localid ASC
length(trim(victiminfoversion.victim_localid))= 0 OR
length(trim(victim.victim_localid))= 0) AND
victiminfoversion.link_only = '0f'
ORDER BY
victim.victim_localid ASC
<pre>
update hazardinfoversion
SET
WHERE
hazardinfoversion.hazard_guid = hazard.hazard_guid ANDhazardinfoversion.link_only = '0f' AND
hazardinfoversion.hazard_localid IS NULL and
hazard.hazard_localid IS NOT NULL
(fieldreport.fieldreport_localid IS NULL or length(trim(fieldreport.fieldreport_localid)) = 0 )
AND
accidentinfoversion.link_only = '0f'
</pre>
(fieldreport.fieldreport_localid IS NULL OR length(trim(fieldreport.fieldreport_localid)) = 0)
AND
hazardinfoversion.link_only = '0f'
</pre>
WHERE
(fieldreport.fieldreport_localid IS NULL or length(trim(fieldreport.fieldreport_localid)) = 0) AND
hazreducinfoversion.link_only = '0f' AND
hazreducinfoversion.hazreduc_localid IS NOT NULL
</pre>
WHERE
(fieldreport.fieldreport_localid IS NULL or length(trim(fieldreport.fieldreport_localid)) = 0 ) AND
locationinfoversion.link_only = '0f'
</pre>
WHERE
( fieldreport.fieldreport_localid is null or length(trim(fieldreport.fieldreport_localid)) = 0) AND
mreinfoversion.link_only = '0f'
</pre>
WHERE
(fieldreport.fieldreport_localid IS NULL or length(trim(fieldreport.fieldreport_localid)) = 0) AND
qainfoversion.link_only = '0f'
</pre>
WHERE
(fieldreport.fieldreport_localid IS NULL or length(trim(fieldreport.fieldreport_localid)) = 0) AND
victiminfoversion.link_only = '0f'
</pre>
WHERE
(fieldreport.fieldreport_localid is null or length(trim(fieldreport.fieldreport_localid)) = 0) and
hazardinfoversion.link_only = '0f' AND
hazardinfoversion.hazard_localid IS NOT NULL
</pre>