How get All Day Name Day Wise of a Month in SQL

--exec spGetAllDayOfAMonth 2012,1
ALTER Procedure [dbo].[spGetAllDayOfAMonth]
@pYear int,@mnth int
AS
BEGIN
SELECT convert(varchar,day(CAST(CAST(@pYear AS VARCHAR) + '-' + CAST(@mnth AS VARCHAR) + '-01' AS DATETIME) + Number )) as SL,
(convert(varchar,day(CAST(CAST(@pYear AS VARCHAR) + '-' + CAST(@mnth AS VARCHAR) + '-01' AS DATETIME) + Number ))
+ '-' +
datename(weekday,CAST(CAST(@pYear AS VARCHAR) + '-' + CAST(@mnth AS VARCHAR) + '-01' AS DATETIME) + Number )) as DayMonth

FROM master..spt_values
WHERE type = 'P'
AND
(CAST(CAST(@pYear AS VARCHAR) + '-' + CAST(@mnth AS VARCHAR) + '-01' AS DATETIME) + Number )
<
DATEADD(mm,1,CAST(CAST(@pYear AS VARCHAR) + '-' + CAST(@mnth AS VARCHAR) + '-01' AS DATETIME))
END