Listing 5: Creation Script for the VPotentialCallPeriods View

CREATE VIEW VPotentialCallPeriods
AS

SELECT
  username,
  firstminute,
  lastminute,
  fromtime + diff + n - 1 AS potentialfrom,
  totime + diff + n - 1 AS potentialto,
  rate
FROM VStartEndCalls
  JOIN Nums
    ON n <= DATEDIFF(day, firstminute, lastminute) + 1
  CROSS JOIN Rates