ایجاد کردن داده ها براساس ماه های سال

[ندااحمدی]

میخواهم وقتی 90 را وارد میکنم اطلاعاتم را براساس ماه های فرودین ....تا اسفند نشان دهد
ALTER PROCEDURE [dbo].[usp_ChartMonthdaSaleTBL_GetByCinemaCode]
(
@CinemaCode int,
@year char(5)

)
AS
BEGIN

declare @sdate char(10)
declare @edate char(10)
set @sdate = '13' + @year + '/01'
set @edate = '13' + @year + '/30'


SELECT

SUBSTRING( d.SalonShowDate ,9,2) + ' ' + d.DayName as mon
,sum(d.[TotalSale]) as total


FROM
[cinemagishe].[DailySaleTBL] as d
WHERE
d.[CinemaCode] = @CinemaCode
and
d.SalonShowDate >=@sdate
and
d.SalonShowDate <= @edate
and
SUBSTRING(d.SalonShowDate ,3,5) = @year

group by d.[SalonShowDate],d.DayName
ORDER BY d.[SalonShowDate]


END