最长的procedure_n2-sum(n3:n21)-CSDN博客

CREATE PROCEDURE dbo.Money_SelectSumInfoByServerId_ffokadmin
@ServerId int
AS
--------------------------------
--------------------------------
DECLARE @Hou MONEY
DECLARE @Yang MONEY
DECLARE @Ma MONEY
DECLARE @She MONEY
DECLARE @Long MONEY
DECLARE @Tu MONEY
DECLARE @Hu MONEY
DECLARE @Niu MONEY
DECLARE @Shu MONEY
DECLARE @Zhu MONEY
DECLARE @Gou MONEY
DECLARE @Ji MONEY
DECLARE @Dan MONEY
DECLARE @Shuang MONEY
DECLARE @Da MONEY
DECLARE @Xiao MONEY
DECLARE @N1 MONEY
DECLARE @N2 MONEY
DECLARE @N3 MONEY
DECLARE @N4 MONEY
DECLARE @N5 MONEY
DECLARE @N6 MONEY
DECLARE @N7 MONEY
DECLARE @N8 MONEY
DECLARE @N9 MONEY
DECLARE @N10 MONEY
DECLARE @N11 MONEY
DECLARE @N12 MONEY
DECLARE @N13 MONEY
DECLARE @N14 MONEY
DECLARE @N15 MONEY
DECLARE @N16 MONEY
DECLARE @N17 MONEY
DECLARE @N18 MONEY
DECLARE @N19 MONEY
DECLARE @N20 MONEY
DECLARE @N21 MONEY
DECLARE @N22 MONEY
DECLARE @N23 MONEY
DECLARE @N24 MONEY
DECLARE @N25 MONEY
DECLARE @N26 MONEY
DECLARE @N27 MONEY
DECLARE @N28 MONEY
DECLARE @N29 MONEY
DECLARE @N30 MONEY
DECLARE @N31 MONEY
DECLARE @N32 MONEY
DECLARE @N33 MONEY
DECLARE @N34 MONEY
DECLARE @N35 MONEY
DECLARE @N36 MONEY
DECLARE @N37 MONEY
DECLARE @N38 MONEY
DECLARE @N39 MONEY
DECLARE @N40 MONEY
DECLARE @N41 MONEY
DECLARE @N42 MONEY
DECLARE @N43 MONEY
DECLARE @N44 MONEY
DECLARE @N45 MONEY
DECLARE @N46 MONEY
DECLARE @N47 MONEY
DECLARE @N48 MONEY
DECLARE @N49 MONEY
--------------------------------
--------------------------------
select @Hou=SUM(Hou),@Yang=SUM(Yang),@Ma=SUM(Ma),@She=SUM(She),@Long=SUM(Long),@Tu=SUM(Tu),@Hu=SUM(Hu),@Niu=SUM(Niu),@Shu=SUM(Shu),@Zhu=SUM(Zhu),@Gou=SUM(Gou),@Ji=SUM(Ji),@Dan=SUM(Dan),@Shuang=SUM(Shuang),@Da=SUM(Da),@Xiao=SUM(Xiao),@N1=SUM(N1),@N2=SUM(N2),@N3=SUM(N3),@N4=SUM(N4),@N5=SUM(N5),@N6=SUM(N6),@N7=SUM(N7),@N8=SUM(N8),@N9=SUM(N9),@N10=SUM(N10),@N11=SUM(N11),@N12=SUM(N12),@N13=SUM(N13),@N14=SUM(N14),@N15=SUM(N15),@N16=SUM(N16),@N17=SUM(N17),@N18=SUM(N18),@N19=SUM(N19),@N20=SUM(N20),@N21=SUM(N21),@N22=SUM(N22),@N23=SUM(N23),@N24=SUM(N24),@N25=SUM(N25),@N26=SUM(N26),@N27=SUM(N27),@N28=SUM(N28),@N29=SUM(N29),@N30=SUM(N30),@N31=SUM(N31),@N32=SUM(N32),@N33=SUM(N33),@N34=SUM(N34),@N35=SUM(N35),@N36=SUM(N36),@N37=SUM(N37),@N38=SUM(N38),@N39=SUM(N39),@N40=SUM(N40),@N41=SUM(N41),@N42=SUM(N42),@N43=SUM(N43),@N44=SUM(N44),@N45=SUM(N45),@N46=SUM(N46),@N47=SUM(N47),@N48=SUM(N48),@N49=SUM(N49) from Money m
join
(select id from [User] where agent = 'ffokadmin') u
on
m.UserId = u.ID
where ServerId=@ServerId
--------------------------------
--------------------------------
DECLARE @agent_idx varchar(40) -- 记录代理名称
DECLARE @agent_tel float -- 记录股份数
DECLARE Agent_Cursor CURSOR FOR
select distinct agent from [user] where id in (select distinct userid from money where ServerId=@ServerId) and agent <> 'ffokadmin'
OPEN Agent_Cursor
----------------------------------------------
-- - - - - - - - - - - - - - - - - - - - - - -
set @agent_idx = '' -- 置空
FETCH NEXT FROM Agent_Cursor INTO @agent_idx