NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
== Example update query==__NOEDITSECTION__
<pre>
UPDATE fieldreport
SET
reportverifieddate = hazreducinfoversion.dataentrydate
FROM imsmaenum, hazreducinfoversion
WHERE
imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid AND
hazreducinfoversion.fieldreport_guid = fieldreport.fieldreport_guid AND
imsmaenum.enumvalue = 'Approved' AND
fieldreport.reportverifieddate IS NULL AND
hazreducinfoversion.link_only = 'f' AND
dateofreport is not NULL AND
dateofreport < hazreducinfoversion.dataentrydate
UPDATE fieldreport
SET
reportverifieddate = dateofreport
FROM imsmaenum, hazreducinfoversion
WHERE
imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid AND
hazreducinfoversion.fieldreport_guid = fieldreport.fieldreport_guid AND
imsmaenum.enumvalue = 'Approved' AND
fieldreport.reportverifieddate IS NULL AND
hazreducinfoversion.link_only = 'f' AND
dateofreport is not NULL AND
dateofreport > hazreducinfoversion.dataentrydate
update fieldreport
SET
verifiedby = fieldreport.dataenterer
FROM imsmaenum, hazreducinfoversion
WHERE
imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid AND
hazreducinfoversion.fieldreport_guid = fieldreport.fieldreport_guid AND
imsmaenum.enumvalue = 'Approved' AND
fieldreport.verifiedby IS NULL AND
hazreducinfoversion.link_only = 'f' and
fieldreport.dataenterer is not null
</pre>
{{NavBox Hub}}
[[Category:NoPublic]]
[[Category:SQL Queries]]