Display the List of Months Between the two dates ---- Procedure & Function

------- List of Months  Procedures

CREATE PROCEDURE Proc_ListOfMonths(@SDate DATETIME,@EDate DATETIME)
AS
BEGIN
DECLARE @I INT
DECLARE @J INT
DECLARE @TAB TABLE (Months DATETIME)
SET @I = 0
SELECT @J = DATEDIFF(MM,@SDate,@EDate)
WHILE (@I<=@J)
BEGIN
INSERT INTO @TAB SELECT DATEADD(MM,@I,@SDate)
SET @I = @I +1
END
SELECT DATEPART(MM,MONTHS) Months  FROM @TAB
END

EXEC Proc_ListOfMonths '2010-06-30 ','2011-06-30'



-----------List of Months Function

CREATE FUNCTION UDF_ListOfMonths (@SDate DATETIME, @EDate DATETIME )
RETURNS @Months TABLE (Months DATETIME )
AS
BEGIN
DECLARE @I INT
DECLARE @J INT
SET @I = 0
SELECT @J = DATEDIFF(MM,@SDate,@EDate)
WHILE (@I<=@J)
BEGIN
INSERT INTO @Months SELECT DATEADD(MM,@I,@SDate)
SET @I = @I +1
END
RETURN
END


SELECT DATEPART(MM,Months)Months FROM UDF_ListOfMonths ('2010-06-30 ','2011-06-30')