Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Dec 7th, 2018 59 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  1. SELECT
  2.   o.OrganisationID,
  3.   o.OrganisationTypeID,
  4.   o.Latitude,
  5.   o.Longitude,
  6.   oht.OpeningHoursType,
  7.   oh.AdditionalOpeningDate,
  8.   CASE
  9.     WHEN oh.DayOfWeek = 7 THEN DATEDIFF(minute, 0, oh.OpeningTime)
  10.     ELSE DATEDIFF(minute, 0, oh.OpeningTime) + (1440 * oh.DayOfWeek)
  11.   END AS OpeningTimeAsOffset,
  12.   CASE
  13.     WHEN oh.DayOfWeek = 7 THEN DATEDIFF(minute, 0, oh.ClosingTime)
  14.     ELSE DATEDIFF(minute, 0, oh.ClosingTime) + (1440 * oh.DayOfWeek)
  15.   END AS ClosingTimeAsOffset,
  16.   oh.DayOfWeek,
  17.   oh.OpeningTime,
  18.   oh.ClosingTime
  19. FROM [choices].[Organisation] o
  20. INNER JOIN choices.OpeningHours oh ON o.[OrganisationID] = oh.[OrganisationID]
  21. INNER JOIN choices.OpeningHoursType oht ON oht.OpeningHoursTypeID = oh.OpeningHoursTypeID
  22. WHERE o.OrganisationTypeID = 'PHA'
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