Skip to content

Instantly share code, notes, and snippets.

@accasey

accasey/update_eperf.sql

Created February 16, 2018 14:49
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save accasey/436f58e1c2ca42b44b195c0249770059 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save accasey/436f58e1c2ca42b44b195c0249770059 to your computer and use it in GitHub Desktop.
Download ZIP
Sanitize ePerformance
Raw
update_eperf.sql
    UPDATE PS_EP_APPR_SECTION SET EP_RESULTS='Data has been cleared.'
/
UPDATE PS_EP_APPR_ITEM SET EP_RESULTS='Data has been cleared.'
/
UPDATE PS_EP_APPR_ITEM SET REVIEW_RATING = 2
/
UPDATE PS_EP_APPR_ITEM SET REVIEW_POINTS = 2
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment