Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. command.CommandText = $@"INSERT INTO c_GDPREntity(c_ObjectId, c_isBeingProcessed)
  2. SELECT c_Id, 0 FROM c_Order WHERE c_id in(select c_orderid from c_OrderLine
  3. WHERE c_OrderLineType = 'service' AND c_Id in (SELECT c_OrderLineid FROM c_OrderLineStatusEvent
  4. WHERE (c_ChangedTo = 'completed' OR c_ChangedTo = 'cancelled') AND GETDATE() > DATEADD(DAY,{daysBeforeAnonymization}, c_ChangedAt)))
  5. AND c_Id NOT IN(SELECT c_ObjectId FROM c_GDPRObjectStatus)";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement