a guest Jan 16th, 2018 65 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- 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