Advertisement
Guest User

Untitled

a guest
Jun 19th, 2018
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. update leaveentitlements
  2. set NumberOfDays = @numberofdays ,
  3. DaysUsed = 0,
  4. FromDate = '2018-01-01',
  5. ToDate = '2018-01-02',
  6. Note = 'qwerty',
  7. ModifiedDate = NOW(),
  8. UpdateCounter = UpdateCounter + 1
  9. where LeaveEntitlementId = @leaveentitlementid;
  10.  
  11. update edges
  12. set
  13. IsDeleted = 0,
  14. DateModified = NOW(),
  15. FromId = @leavetypeid,
  16. UpdateCounter = UpdateCounter + 1
  17. where ToId = @leaveentitlementid and (FromType = 'LeaveType' and ToType = 'LeaveEntitlement');
  18.  
  19. update edges
  20. set
  21. IsDeleted = 0,
  22. DateModified = NOW(),
  23. FromId = @leaveprtiodid,
  24. UpdateCounter = UpdateCounter + 1
  25. where ToId = @leaveentitlementid and (FromType = 'LeavePeriod' and ToType = 'LeaveEntitlement');
  26.  
  27. update edges
  28. set
  29. IsDeleted = 0,
  30. DateModified = NOW(),
  31. FromId = @employeeid,
  32. UpdateCounter = UpdateCounter + 1
  33. where ToId = @leaveentitlementid and (FromType = 'Employee' and ToType = 'LeaveEntitlement');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement