存储过程 按月统计格式转换

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER PROCEDURE [dbo].[www]
@time datetime,
@m_id int
AS
IF   (@m_id   IS   NOT   NULL)
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    SELECT msbmc,hwm,ssts,ssje,time1,dtb.mid
from dtb join jsb on dtb.jid = jsb.jid
         join hwzl on dtb.hid=hwzl.hid
        join msbzl on dtb.mid=msbzl.mid
where (DATENAME(year,time1)+datename(month,time1))=(DATENAME(year,@time)+datename(month,@time))
and dtb.mid =@m_id
end
else
begin
    SELECT msbmc,hwm,ssts,ssje,time1,dtb.mid
from dtb join jsb on dtb.jid = jsb.jid
         join hwzl on dtb.hid=hwzl.hid
        join msbzl on dtb.mid=msbzl.mid


where (DATENAME(year,time1)+datename(month,time1))=(DATENAME(year,@time)+datename(month,@time))
END