SELECT t.name 
FROM sys.tables t
JOIN (SELECT '%' + CAST(QFM + m AS VARCHAR) AS QM
      FROM ( SELECT CAST(YEAR(GETDATE()) AS VARCHAR(4))
           + RIGHT('0' + CAST(DATEPART(QUARTER,GETDATE()) * 3 AS VARCHAR(2)),2) AS QFM ) q
      CROSS JOIN (SELECT 0 m UNION ALL SELECT 1 m UNION ALL SELECT 2 m) m
      ) qm3
ON  t.name LIKE qm3.QM

 SELECT st.Name
   FROM sys.tables st
  WHERE RIGHT(st.Name,6) IN
        ( 
         SELECT CONVERT(CHAR(6), DATEADD(mm,t.N,DATEADD(qq,DATEDIFF(qq,0,GETDATE()),0)), 112)
           FROM (SELECT 0 UNION ALL SELECT 1 UNION ALL SELECT 2) t (N)
        )
;