DECLARE @Table TABLE (FromDate DATETIME, ToDate DATETIME, ResultDate DATETIME)INSERT INTO @Table VALUES('2012-01-01','2012-03-31','2011-12-31'),('2012-04-01','2012-06-30','2012-03-31'),('2012-07-01','2012-09-30','2012-06-30'),('2012-10-01','2012-12-31','2012-09-30')SELECT ResultDateFROM @TableWHERE GETDATE() >= FromDate AND GETDATE() <= ToDate
declare @ThisDate datetime;set @ThisDate = getdate();select @ThisDate, dateadd(qq, datediff(qq, 0, @ThisDate), -1);set @ThisDate = '20120507';select @ThisDate, dateadd(qq, datediff(qq, 0, @ThisDate), -1);