API tools faq
paste
Guest User

Untitled

a guest
Jan 3rd, 2018
73
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.99 KB | None | 0 0
raw download clone embed print report
  1. IF OBJECT_ID('tempdb..#MyData') IS NOT NULL DROP TABLE #MyData
  2. CREATE TABLE #MyData (
  3. ScheduleTimesId INT,
  4. ScheduleId INT,
  5. FacilityId INT,
  6. ApptTypeId INT,
  7. SlotTimeStart DATETIME,
  8. SlotTimeStop DATETIME,
  9. ApptTimeStart DATETIME,
  10. ApptTimeStop DATETIME,
  11. ApptType VARCHAR(30)
  12. )
  13. INSERT INTO #MyData
  14. VALUES
  15. ('75999','2124','499','161','1900-01-01 09:00:00.000','1900-01-01 09:20:00.000','1900-01-01 09:00:00.000','1900-01-01 10:00:00.000','Mandatory Dept Meeting')
  16. ,('76000','2124','499',NULL,'1900-01-01 09:20:00.000','1900-01-01 09:40:00.000',NULL,NULL,NULL)
  17. ,('76001','2124','499',NULL,'1900-01-01 09:40:00.000','1900-01-01 10:00:00.000',NULL,NULL,NULL)
  18. ,('76002','2124','499','167','1900-01-01 10:00:00.000','1900-01-01 10:20:00.000','1900-01-01 10:00:00.000','1900-01-01 11:00:00.000','Admin Time')
  19. ,('76003','2124','499',NULL,'1900-01-01 10:20:00.000','1900-01-01 10:40:00.000',NULL,NULL,NULL)
  20. ,('76004','2124','499',NULL,'1900-01-01 10:40:00.000','1900-01-01 11:00:00.000',NULL,NULL,NULL)
  21. ,('76005','2124','499','167','1900-01-01 11:00:00.000','1900-01-01 11:20:00.000','1900-01-01 11:00:00.000','1900-01-01 12:00:00.000','Admin Time')
  22. ,('76006','2124','499',NULL,'1900-01-01 11:20:00.000','1900-01-01 11:40:00.000',NULL,NULL,NULL)
  23. ,('76007','2124','499',NULL,'1900-01-01 11:40:00.000','1900-01-01 12:00:00.000',NULL,NULL,NULL)
  24. ,('76008','2124','499','168','1900-01-01 12:00:00.000','1900-01-01 12:20:00.000','1900-01-01 12:00:00.000','1900-01-01 13:00:00.000','LUNCH - 60 MIN')
  25. ,('76009','2124','499',NULL,'1900-01-01 12:20:00.000','1900-01-01 12:40:00.000',NULL,NULL,NULL)
  26. ,('76010','2124','499',NULL,'1900-01-01 12:40:00.000','1900-01-01 13:00:00.000',NULL,NULL,NULL)
  27. ,('76011','2124','499','160','1900-01-01 13:00:00.000','1900-01-01 13:20:00.000','1900-01-01 13:00:00.000','1900-01-01 15:00:00.000','Team Meeting')
  28. ,('76012','2124','499',NULL,'1900-01-01 13:20:00.000','1900-01-01 13:40:00.000',NULL,NULL,NULL)
  29. ,('76013','2124','499',NULL,'1900-01-01 13:40:00.000','1900-01-01 14:00:00.000',NULL,NULL,NULL)
  30. ,('76014','2124','499',NULL,'1900-01-01 14:00:00.000','1900-01-01 14:20:00.000',NULL,NULL,NULL)
  31. ,('76015','2124','499',NULL,'1900-01-01 14:20:00.000','1900-01-01 14:40:00.000',NULL,NULL,NULL)
  32. ,('76016','2124','499',NULL,'1900-01-01 14:40:00.000','1900-01-01 15:00:00.000',NULL,NULL,NULL)
  33. ,('76017','2124','499',NULL,'1900-01-01 15:00:00.000','1900-01-01 15:20:00.000',NULL,NULL,NULL)
  34. ,('76018','2124','499','191','1900-01-01 15:20:00.000','1900-01-01 15:40:00.000','1900-01-01 15:20:00.000','1900-01-01 15:40:00.000','MD Return 20')
  35. ,('76019','2124','499','191','1900-01-01 15:40:00.000','1900-01-01 16:00:00.000','1900-01-01 15:40:00.000','1900-01-01 16:00:00.000','MD Return 20')
  36. ,('76020','2124','499',NULL,'1900-01-01 16:00:00.000','1900-01-01 16:20:00.000',NULL,NULL,NULL)
  37. ,('76021','2124','499',NULL,'1900-01-01 16:20:00.000','1900-01-01 16:40:00.000',NULL,NULL,NULL)
  38. ,('76022','2124','499','191','1900-01-01 16:40:00.000','1900-01-01 17:00:00.000','1900-01-01 16:40:00.000','1900-01-01 17:00:00.000','MD Return 20')
  39. SELECT * FROM #MyData
Add Comment
Please, Sign In to add comment
Public Pastes
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!