Useful SQL

Problematic CV's
We've had a couple of calls recently where users have been able to load a CV in to IQX when adding a new candidate but when they go to the CV tab in I...
Thu, 21 Jun, 2018 at 10:27 AM
See IQX Backup event start time within SQLTool
Run in SQLTool to see what time the nightly backup for Monday, Wednesday and Friday starts.  Change MWF to TTS for the second backup in a routine. This wi...
Thu, 21 Jun, 2018 at 10:30 AM
Update ALL users to hide the P45 button from the person form.
INSERT INTO WPKAssignedRole (OwnerID, WPKRoleID) ON EXISTING SKIP SELECT Staffid, 'HIDEPP45' FROM Staff
Thu, 21 Jun, 2018 at 10:31 AM
JPEG error 53
Select * from person where name = ‘xxx’ to get personid Then select * from blobstore where  class='j' and  id= <personid> double check t...
Thu, 21 Jun, 2018 at 10:32 AM
Changing File Paths for Timesheet Images
After a Server move clients that link images to their timesheets will need the file paths updated so that images that were linked before the server move can...
Thu, 21 Jun, 2018 at 10:36 AM
Pegasus Payroll Transfer Issues and how to fix SQL
This contains information on how to add in missing info to the shared tables and how to set the transfer batch back if it needs to be re-run MISSING INFO ...
Thu, 21 Jun, 2018 at 10:37 AM
Find and edit the date when candidates were last updated
Find candidates who were last updated in a certain year e.g. 2009; select * from person where changedate = '2009' Update the date of an indiv...
Wed, 18 Jul, 2018 at 10:10 AM