sqlserver 函数
发布时间：2020-12-12 12:48:53 所属栏目：MsSql教程 来源：网络整理
导读：CREATE function [dbo].[fn_test](@y int,@m int) returns @temp table(项目名称 varchar(100),上旬销售套数 varchar(100),中旬销售套数 varchar(100),下旬销售套数 varchar(100)) as? begin declare @dybm varchar(80) ? declare @上旬销售套数 int declare
|
CREATE function [dbo].[fn_test](@y int,@m int) returns @temp table(项目名称 varchar(100),上旬销售套数 varchar(100),中旬销售套数 varchar(100),下旬销售套数 varchar(100)) as? begin declare @dybm varchar(80) ? declare @上旬销售套数 int declare @中旬销售套数 int declare @下旬销售套数 int declare @company varchar(100) select @上旬销售套数= ?COUNT(b.projguid) from dbo.s_room as a left join dbo.s_project as b on a.projguid=b.projguid where YEAR(qsdate)=@y and MONTH(qsdate)=@m and day(a.qsdate)>0 and day(a.qsdate)<=10 group by b.projguid set @上旬销售套数 =@@ROWCOUNT if(@上旬销售套数 is null) begin set @上旬销售套数=0 end select @中旬销售套数=COUNT(b.projguid) from dbo.s_room as a left join dbo.s_project as b on a.projguid=b.projguid where YEAR(qsdate)=@y and MONTH(qsdate)=@m ?and day(a.qsdate)>10 and day(a.qsdate)<=20 group by b.projguid set @中旬销售套数 =@@ROWCOUNT if(@中旬销售套数 is null) begin set @中旬销售套数=0 end select @下旬销售套数= COUNT(b.projguid) from dbo.s_room as a left join dbo.s_project as b on a.projguid=b.projguid where YEAR(qsdate)=@y and MONTH(qsdate)=@m ?and day(a.qsdate)>20 and day(a.qsdate)<=30 group by b.projguid set @下旬销售套数 =@@ROWCOUNT if(@下旬销售套数 is null) begin set @下旬销售套数=0 end select @company= b.company from dbo.s_room as a left join dbo.s_project as b on a.projguid=b.projguid where YEAR(qsdate)=@y and MONTH(qsdate)=@m ? insert @temp values(@company,@上旬销售套数,@中旬销售套数,@下旬销售套数) return? end select * from [fn_test] (2013,4)
（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |