```sql
WITH
source_data
AS
(
	SELECT
		  [today_date] = CONVERT(DATETIME, CONVERT(DATE, GETDATE()))
		, [today_year] = YEAR(GETDATE())
		, [today_month] = MONTH(GETDATE())
)
SELECT
	  [Period] = CONVERT(VARCHAR(100), 'Year To Date')
	, [BeginDate] = DATEFROMPARTS([today_year], 1, 1)
	, [EndDate] = [today_date]
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Today'
	, [BeginDate] = [today_date]
	, [EndDate] = [today_date]
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Yesterday'
	, [BeginDate] = DATEADD(DAY, -1, [today_date])
	, [EndDate] = DATEADD(DAY, -1, [today_date])
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Fiscal Year To Date'
	, [BeginDate] = DATEFROMPARTS([today_year], 10, 1)
	, [EndDate] = [today_date]
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Month To Date'
	, [BeginDate] = DATEFROMPARTS([today_year], [today_month], 1)
	, [EndDate] = [today_date]
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last Month'
	, [BeginDate] = DATEFROMPARTS([today_year], [today_month] - 1, 1)
	, [EndDate] = DATEADD(DAY, -1, DATEFROMPARTS([today_year], [today_month], 1))
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last Month to Date'
	, [BeginDate] = DATEFROMPARTS([today_year], [today_month] - 1, 1)
	, [EndDate] = DATEADD(MONTH, -1, [today_date])
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last Year'
	, [BeginDate] = DATEFROMPARTS([today_year] - 1, 1, 1)
	, [EndDate] = DATEFROMPARTS([today_year] - 1, 12, 31)
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last Year to Date'
	, [BeginDate] = DATEFROMPARTS([today_year] - 1, 1, 1)
	, [EndDate] = DATEADD(DAY, -1, [today_date])
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last 7 Days'
	, [BeginDate] = DATEADD(DAY, -7, [today_date])
	, [EndDate] = [today_date]
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last 14 Days'
	, [BeginDate] = DATEADD(DAY, -14, [today_date])
	, [EndDate] = [today_date]
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last 21 Days'
	, [BeginDate] = DATEADD(DAY, -21, [today_date])
	, [EndDate] = [today_date]
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last 28 Days'
	, [BeginDate] = DATEADD(DAY, -28, [today_date])
	, [EndDate] = [today_date]
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last 30 Days'
	, [BeginDate] = DATEADD(DAY, -30, [today_date])
	, [EndDate] = [today_date]
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last 60 Days'
	, [BeginDate] = DATEADD(DAY, -60, [today_date])
	, [EndDate] = [today_date]
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last 90 Days'
	, [BeginDate] = DATEADD(DAY, -90, [today_date])
	, [EndDate] = [today_date]
FROM source_data
UNION ALL
SELECT
	  [Period] = 'This Calendar Quarter'
	, [BeginDate] = DATEADD(qq, DATEDIFF(q, 0, [today_date]), 0)
	, [EndDate] = DATEADD(qq, DATEDIFF(q, 0, [today_date]) + 1, 0) - 1
FROM source_data
UNION ALL
SELECT
	  [Period] = 'This Calendar Quarter to Date'
	, [BeginDate] = DATEADD(qq, DATEDIFF(q, 0, [today_date]), 0)
	, [EndDate] = [today_date]
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last Calendar Quarter'
	, [BeginDate] = DATEADD(qq, DATEDIFF(q, 2, [today_date]) - 1, 0)
	, [EndDate] = DATEADD(qq, DATEDIFF(q, 2, [today_date]), 0) - 1
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last Calendar Quarter to Date'
	, [BeginDate] = DATEADD(qq, DATEDIFF(q, 0, [today_date]) - 1, 0)
	, [EndDate] = DATEADD(qq, - 1, [today_date])
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last Year Calendar Quarter'
	, [BeginDate] = DATEADD(YEAR, - 1, DATEADD(qq, DATEDIFF(q, 2, [today_date]), 0))
	, [EndDate] = DATEADD(YEAR, - 1, DATEADD(qq, DATEDIFF(q, 2, [today_date]) + 1, 0) - 1)
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Last Year Calendar Quarter to Date'
	, [BeginDate] = DATEADD(YEAR, - 1, DATEADD(qq, DATEDIFF(q, 2, [today_date]), 0))
	, [EndDate] = DATEADD(YEAR, -1, [today_date])
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Next Year'
	, [BeginDate] = DATEFROMPARTS([today_year] + 1, 1, 1)
	, [EndDate] = DATEFROMPARTS([today_year] + 1, 12, 31)
FROM source_data
UNION ALL
SELECT
	  [Period] = 'Next Year to Date'
	, [BeginDate] = DATEFROMPARTS([today_year] + 1, 1, 1)
	, [EndDate] = DATEADD(YEAR, 1, [today_date])
FROM source_data
GO
```