daily pastebin goal
0%
SHARE
TWEET

Untitled

a guest Feb 13th, 2018 65 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT Property.PropertyID, Property.Name, BTAT.Action as Status, BTAT.Total, BTAT.BookingID, DateTimeCreatedRealtime
  2. FROM BookingTotalAuditTrail as BTAT
  3. LEFT JOIN Booking ON Booking.BookingID=BTAT.BookingID
  4. LEFT JOIN PropertyBooking ON BTAT.BookingID=PropertyBooking.BookingID
  5. LEFT JOIN Property ON PropertyBooking.PropertyID=Property.PropertyID
  6. WHERE (PropertyBooking.PropertyID IN(25)) AND (DateTimeCreatedRealTime BETWEEN CAST('2018-02-13 00:00:00' as datetime) AND CAST('2018-02-14 23:59:59' as datetime))
  7. ORDER BY DateTimeCreatedRealtime DESC
  8.    
  9. PropertyID  Name                    Status      Total BookingID DateTimeCreatedRealTime
  10. 25          Beach Resort & Villas   Modified    543   747890    2018-02-13 09:56:40
  11. 25          Beach Resort & Villas   Modified    499   747890    2018-02-13 09:56:21
  12. 25          Beach Resort & Villas   Modified    499   747890    2018-02-13 09:56:19
  13. 25          Beach Resort & Villas   New         277   747890    2018-02-13 09:56:09
  14.    
  15. PropertyID  Name                    Status      Total BookingID DateTimeCreatedRealTime
  16. 25          Beach Resort & Villas   Modified    543   747890    2018-02-13 09:56:40
  17. 25          Beach Resort & Villas   New         277   747890    2018-02-13 09:56:09
  18.    
  19. GROUP BY Property.PropertyID, Property.Name, BTAT.Action, BTAT.BookingID
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top