SHARE
TWEET

Untitled

a guest Jul 21st, 2019 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select d.FullDate,
  2.   a.ApptDescription,
  3.   a.ApptStartDate + a.ApptStartTime AS ApptStart,
  4.   a.ApptEndDate + a.ApptEndTime AS ApptEnd
  5. from DimDate AS d
  6. left join Appointments AS a
  7.   on d.FullDate = a.ApptStartDate
  8. order by d.FullDate;
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top