Skip to content

Instantly share code, notes, and snippets.

@srkirkland

srkirkland/updatestatuscodes.sql

Created August 6, 2015 23:20
Show Gist options
  • Save srkirkland/b0c00847ba12128e361f to your computer and use it in GitHub Desktop.
Save srkirkland/b0c00847ba12128e361f to your computer and use it in GitHub Desktop.
Download ZIP
update some status codes
Raw
updatestatuscodes.sql
select * from Gifts where Status = 'Completed' and StatusLevel = 10 --if any results we are on old scheme
update Gifts set StatusLevel = StatusLevel + 1 where StatusLevel > 5 --move all gifts financial review or higher up a level
update Gifts set StatusLevel = StatusLevel + 2 where StatusLevel = 5 --move from financial hold to financial review
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment