To find out the quarter start date and end date

USE [reddy]
GO
/****** Object: StoredProcedure [dbo].[usp_GetQuaterStartAndEndDates] Script Date: 02/26/2011 23:41:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[usp_GetQuaterStartAndEndDates]
AS
BEGIN
Declare @Q_StartDate Datetime
Declare @Q_EndDate Datetime
Declare @Qno Int

SELECT @Qno = DATEPART(QQ,GETDATE())

IF @Qno = 1
BEGIN
SET @Q_StartDate = '01-01-' + Convert(Varchar(10),(DATEPART(YY,GETDATE())))
SET @Q_EndDate = '03-31-' + Convert(Varchar(10),(DATEPART(YY,GETDATE())))
END
ELSE IF @Qno = 2
BEGIN
SET @Q_StartDate = '04-01-' + Convert(Varchar(10),(DATEPART(YY,GETDATE())))
SET @Q_EndDate = '06-30-' + Convert(Varchar(10),(DATEPART(YY,GETDATE())))
END
ELSE IF @Qno = 3
BEGIN
SET @Q_StartDate = '07-01-' + Convert(Varchar(10),(DATEPART(YY,GETDATE())))
SET @Q_EndDate = '09-30-' + Convert(Varchar(10),(DATEPART(YY,GETDATE())))
END
ELSE IF @Qno = 4
BEGIN
SET @Q_StartDate = '10-01-' + Convert(Varchar(10),(DATEPART(YY,GETDATE())))
SET @Q_EndDate = '12-31-' + Convert(Varchar(10),(DATEPART(YY,GETDATE())))
END

SELECT @Q_StartDate AS BEGINNINGDATE, @Q_EndDate as ENDDATE
END