daily pastebin goal
42%
SHARE
TWEET

Untitled

a guest Jan 16th, 2018 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT OrderId, SubscriberKey, EmailAddress, CancelledAt, Fulfillment, UpdatedAt FROM [OrderDE] WHERE Fulfillment = 'fulfilled' AND CONVERT(datetime, UpdatedAt) <=DATEADD(hour, -1, CONVERT(datetime, GETDATE())) AND CONVERT(datetime, UpdatedAt) >= DATEADD(hour, -2, CONVERT(datetime, GETDATE()))
RAW Paste Data
Top