SELECT     'Last 7 Days' AS Date_Range, CONVERT(smalldatetime, { fn curDATE() }) - 6 AS Begin_Date, CONVERT(smalldatetime, { fn curDATE() }) 
                      AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Today' AS Date_Range, CONVERT(smalldatetime, { fn curDATE() }) AS Begin_Date, CONVERT(smalldatetime, { fn curDATE() }) AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Current Year to Date' AS Date_Range, DATEADD(yy, DATEDIFF(yy, 0, getdate()), 0) AS Begin_Date, CONVERT(smalldatetime, { fn curDATE() }) 
                      AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Yesterday' AS Date_Range, CONVERT(smalldatetime, { fn curDATE() }) - 1 AS Begin_Date, CONVERT(smalldatetime, { fn curDATE() }) 
                      - 1 AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Current Month to Date' AS Date_Range, DATEADD(mm, DATEDIFF(mm, 0, getdate()), 0) AS Begin_Date, CONVERT(smalldatetime, { fn curDATE() }) 
                      AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Current Week to Date' AS Date_Range, CONVERT(smalldatetime, { fn curDATE() }) - DATEPART(dw, CONVERT(smalldatetime, { fn curDATE() }) - 1) 
                      AS Begin_Date, CONVERT(smalldatetime, { fn curDATE() }) AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Current Quarter to Date' AS Date_Range, DATEADD(qq, DATEDIFF(qq, 0, getdate()), 0) AS Begin_Date, CONVERT(smalldatetime, { fn curDATE() }) 
                      AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Previous Month' AS Date_Range, dateadd(mm, - 1, DATEADD(mm, DATEDIFF(mm, 0, getdate()), 0)) AS Begin_Date, dateadd(dd, - 1, DATEADD(mm, 
                      DATEDIFF(mm, 0, getdate()), 0)) AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Previous Week' AS Date_Range, CONVERT(smalldatetime, { fn curDATE() }) - DATEPART(dw, CONVERT(smalldatetime, { fn curDATE() })) 
                      - 6 AS Begin_Date, CONVERT(smalldatetime, { fn curDATE() }) - DATEPART(dw, CONVERT(smalldatetime, { fn curDATE() })) AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Previous Year' AS Date_Range, CONVERT(datetime, cast(datepart(yyyy, GETDATE()) - 1 AS char(4)) + '-01-01') AS Begin_Date, CONVERT(datetime, 
                      cast(datepart(yyyy, GETDATE()) - 1 AS char(4)) + '-12-31') AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Same Day Previous Week' AS Date_Range, CONVERT(smalldatetime, { fn curDATE() }) - 7 AS Begin_Date, CONVERT(smalldatetime, { fn curDATE() }) 
                      - 7 AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Previous Year Month to Date' AS Date_Range, CONVERT(datetime, cast(datepart(yyyy, getdate()) - 1 AS char(4)) + CASE WHEN datepart(mm, getdate()) 
                      < 10 THEN '-0' + cast(datepart(mm, getdate()) AS char(1)) ELSE '-' + cast(datepart(mm, getdate()) AS char(2)) END + '-01') AS Begin_Date, 
                      CONVERT(datetime, cast(datepart(yyyy, getdate()) - 1 AS char(4)) + CASE WHEN datepart(mm, getdate()) < 10 THEN '-0' + cast(datepart(mm, getdate()) 
                      AS char(1)) ELSE '-' + cast(datepart(mm, getdate()) AS char(2)) END + CASE WHEN datepart(d, getdate()) < 10 THEN '-0' + cast(datepart(d, getdate()) 
                      AS char(1)) ELSE '-' + cast(datepart(d, getdate()) AS char(2)) END) AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Previous Year Year to Date' AS Date_Range, CONVERT(datetime, cast(datepart(yyyy, GETDATE()) - 1 AS char(4)) + '-01-01') AS Begin_Date, 
                      CONVERT(datetime, cast(datepart(yyyy, getdate()) - 1 AS char(4)) + CASE WHEN datepart(mm, getdate()) < 10 THEN '-0' + cast(datepart(mm, getdate()) 
                      AS char(1)) ELSE '-' + cast(datepart(mm, getdate()) AS char(2)) END + CASE WHEN datepart(d, getdate()) < 10 THEN '-0' + cast(datepart(d, getdate()) 
                      AS char(1)) ELSE '-' + cast(datepart(d, getdate()) AS char(2)) END) AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Previous Year Quarter to Date' AS Date_Range, CONVERT(datetime, cast(datepart(yyyy, getdate()) - 1 AS char(4)) + CASE WHEN datepart(q, getdate()) 
                      = 1 THEN '-01-01' WHEN datepart(q, getdate()) = 2 THEN '-04-01' WHEN datepart(q, getdate()) = 3 THEN '-07-01' ELSE '-10-01' END) AS Begin_Date, 
                      CONVERT(datetime, cast(datepart(yyyy, getdate()) - 1 AS char(4)) + CASE WHEN datepart(mm, getdate()) < 10 THEN '-0' + cast(datepart(mm, getdate()) 
                      AS char(1)) ELSE '-' + cast(datepart(mm, getdate()) AS char(2)) END + CASE WHEN datepart(d, getdate()) < 10 THEN '-0' + cast(datepart(d, getdate()) 
                      AS char(1)) ELSE '-' + cast(datepart(d, getdate()) AS char(2)) END) AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Same Day Previous Year' AS Date_Range, CONVERT(datetime, cast(datepart(yyyy, getdate()) - 1 AS char(4)) + CASE WHEN datepart(mm, getdate()) 
                      < 10 THEN '-0' + cast(datepart(mm, getdate()) AS char(1)) ELSE '-' + cast(datepart(mm, getdate()) AS char(2)) END + CASE WHEN datepart(d, getdate()) 
                      < 10 THEN '-0' + cast(datepart(d, getdate()) AS char(1)) ELSE '-' + cast(datepart(d, getdate()) AS char(2)) END) AS Begin_Date, CONVERT(datetime, 
                      cast(datepart(yyyy, getdate()) - 1 AS char(4)) + CASE WHEN datepart(mm, getdate()) < 10 THEN '-0' + cast(datepart(mm, getdate()) AS char(1)) 
                      ELSE '-' + cast(datepart(mm, getdate()) AS char(2)) END + CASE WHEN datepart(d, getdate()) < 10 THEN '-0' + cast(datepart(d, getdate()) AS char(1)) 
                      ELSE '-' + cast(datepart(d, getdate()) AS char(2)) END) AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Previous Year Previous Month' AS Date_Range, CONVERT(datetime, CASE WHEN datepart(mm, getdate()) = 1 THEN cast(datepart(yyyy, getdate()) 
                      - 2 AS char(4)) ELSE cast(datepart(yyyy, getdate()) - 1 AS char(4)) END + CASE WHEN datepart(mm, getdate()) = 1 THEN '-12' WHEN datepart(mm, 
                      getdate()) - 1 < 10 THEN '-0' + cast(datepart(mm, getdate()) - 1 AS char(1)) ELSE '-' + cast(datepart(mm, getdate()) - 1 AS char(2)) END + '-01') 
                      AS Begin_Date, CONVERT(datetime, cast(datepart(yyyy, getdate()) - 1 AS char(4)) + CASE WHEN datepart(mm, getdate()) 
                      < 10 THEN '-0' + cast(datepart(mm, getdate()) AS char(1)) ELSE '-' + cast(datepart(mm, getdate()) AS char(2)) END + '-01') - 1 AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Last 30 Days' AS Date_Range, CONVERT(smalldatetime, { fn curDATE() }) - 29 AS Begin_Date, CONVERT(smalldatetime, { fn curDATE() }) 
                      AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Previous Year Last 30 Days' AS Date_Range, CONVERT(datetime, cast(datepart(yyyy, getdate()) - 1 AS char(4)) + CASE WHEN datepart(mm, getdate()) 
                      < 10 THEN '-0' + cast(datepart(mm, getdate()) AS char(1)) ELSE '-' + cast(datepart(mm, getdate()) AS char(2)) END + CASE WHEN datepart(d, getdate()) 
                      < 10 THEN '-0' + cast(datepart(d, getdate()) AS char(1)) ELSE '-' + cast(datepart(d, getdate()) AS char(2)) END) - 29 AS Begin_Date, CONVERT(datetime, 
                      cast(datepart(yyyy, getdate()) - 1 AS char(4)) + CASE WHEN datepart(mm, getdate()) < 10 THEN '-0' + cast(datepart(mm, getdate()) AS char(1)) 
                      ELSE '-' + cast(datepart(mm, getdate()) AS char(2)) END + CASE WHEN datepart(d, getdate()) < 10 THEN '-0' + cast(datepart(d, getdate()) AS char(1)) 
                      ELSE '-' + cast(datepart(d, getdate()) AS char(2)) END) AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Previous Year Last 7 Days' AS Date_Range, CONVERT(datetime, cast(datepart(yyyy, getdate()) - 1 AS char(4)) + CASE WHEN datepart(mm, getdate()) 
                      < 10 THEN '-0' + cast(datepart(mm, getdate()) AS char(1)) ELSE '-' + cast(datepart(mm, getdate()) AS char(2)) END + CASE WHEN datepart(d, getdate()) 
                      < 10 THEN '-0' + cast(datepart(d, getdate()) AS char(1)) ELSE '-' + cast(datepart(d, getdate()) AS char(2)) END) - 6 AS Begin_Date, CONVERT(datetime, 
                      cast(datepart(yyyy, getdate()) - 1 AS char(4)) + CASE WHEN datepart(mm, getdate()) < 10 THEN '-0' + cast(datepart(mm, getdate()) AS char(1)) 
                      ELSE '-' + cast(datepart(mm, getdate()) AS char(2)) END + CASE WHEN datepart(d, getdate()) < 10 THEN '-0' + cast(datepart(d, getdate()) AS char(1)) 
                      ELSE '-' + cast(datepart(d, getdate()) AS char(2)) END) AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Previous Month to Date' AS Date_Range, dateadd(mm, - 1, DATEADD(mm, DATEDIFF(mm, 0, getdate()), 0)) AS Begin_Date, dateadd(mm, - 1, getdate()) 
                      AS End_Date
FROM         dbo.syscolumns
UNION
SELECT     'Current Year to Month' AS Date_Range, DATEADD(yy, DATEDIFF(yy, 0, getdate()), 0) AS Begin_Date, dateadd(dd, - 1, DATEADD(mm, DATEDIFF(mm, 0, 
                      getdate()), 0)) AS End_Date
FROM         dbo.syscolumns