Query to display day in sp

Hi,

Try this SP,

CREATE PROCEDURE getDaysBetweenTwoDate
(
@FromDate DATETIME,
@ToDate DATETIME,
@dayOfWeek int -- should be 1 to 7 [sunday - satuday]
)
AS
BEGIN

DECLARE @TOTALCount INT
SET @FromDate = DATEADD(DAY,-1,@FromDate)
Select @TOTALCount= DATEDIFF(DD,@FromDate,@ToDate);

WITH d AS
(
SELECT top (@TOTALCount) AllDays = DATEADD(DAY, ROW_NUMBER()
OVER (ORDER BY object_id), REPLACE(@FromDate,'-',''))
FROM sys.all_objects
)

SELECT alldays, datepart(dw, alldays) From d where datepart(dw, alldays) = @dayOfWeek

RETURN
END
GO

Exec getAllDaysBetweenTwoDate '06-01-2013','30-06-2014' ,1