How do I undelete a user that has been deleted?

The following SQL can be run against the YF database to restore a delete user. User ID must be obtained from the IPCLASS table to use the SQL script below.

Important - it is always best practice to back-up your database before any delete functions are performed.

update StaffMemberRole
set enddate ='9999-12-31 00:00:00.000'
where IpEmployee=<insert ID here>

update IpRltshp
set EndDate='9999-12-31 00:00:00.000'
where IpChild = <insert ID here>

update IpClass
set EndDate='9999-12-31 00:00:00.000'
where IpId=<insert ID here>