Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update leaveentitlements
- set NumberOfDays = @numberofdays ,
- DaysUsed = 0,
- FromDate = '2018-01-01',
- ToDate = '2018-01-02',
- Note = 'qwerty',
- ModifiedDate = NOW(),
- UpdateCounter = UpdateCounter + 1
- where LeaveEntitlementId = @leaveentitlementid;
- update edges
- set
- IsDeleted = 0,
- DateModified = NOW(),
- FromId = @leavetypeid,
- UpdateCounter = UpdateCounter + 1
- where ToId = @leaveentitlementid and (FromType = 'LeaveType' and ToType = 'LeaveEntitlement');
- update edges
- set
- IsDeleted = 0,
- DateModified = NOW(),
- FromId = @leaveprtiodid,
- UpdateCounter = UpdateCounter + 1
- where ToId = @leaveentitlementid and (FromType = 'LeavePeriod' and ToType = 'LeaveEntitlement');
- update edges
- set
- IsDeleted = 0,
- DateModified = NOW(),
- FromId = @employeeid,
- UpdateCounter = UpdateCounter + 1
- where ToId = @leaveentitlementid and (FromType = 'Employee' and ToType = 'LeaveEntitlement');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement