Create Procedure Patongjixx @ DateTimes DateTime, @ DateTimee DateTime As Declare @tbtiqu Table (Aid Int Id "(1), Anbie Varchar (40), XIaqu Varchar (24), ISXingshi Bit)
Declare @TBXIAQU TABLE (XID Int Idness (1, 1), xxiaqu varchar (24))
declare @tbResult table (rid int identity (1,1), rxiaqu varchar (24), xingHeji int, sharen int, qiangjie int, daoqie int, daoqieJ int, qiangjian int, baozha int, toudu int, fandu int, xingQita int, Int, Zaihai Int, Huojing Int, Shigu Int, JQita Int, Qiuzhu Int, Zixuan Int, Sarao Int, Wqita Int, Zong Int
declare @ a1 intdeclare @ a2 intdeclare @ a3 intdeclare @ a4 intdeclare @ a5 intdeclare @ a6 intdeclare @ a7 intdeclare @ a8 intdeclare @ a9 intdeclare @ a10 intdeclare @ a11 intdeclare @ a12 intdeclare @ a13 intdeclare @ a14 intdeclare @ a15 intdeclare @ a16 intdeclare @ A17 INTDECLARE @ a18 intDeclare @ a19 intDeclare @ a20 int
declare @ b1 intdeclare @ b2 intdeclare @ b3 intdeclare @ b4 intdeclare @ b5 intdeclare @ b6 intdeclare @ b7 intdeclare @ b8 intdeclare @ b9 intdeclare @ b10 intdeclare @ b11 intdeclare @ b12 intdeclare @ b13 intdeclare @ b14 intdeclare @ b15 intdeclare @ b16 intdeclare @ B17 INTDECLARE @ b18 intDeclare @ b19 intDeclare @ b20 int
Set @ b1 = 0set @ b2 = 0set @ b3 = 0set @ b4 = 0set @ b5 = 0set @ b6 = 0set @ b7 = 0set @ b8 = 0set @ b9 = 0set @ b10 = 0set @ b11 = 0set @ b12 = 0set @ B13 = 0SET @ B14 = 0set @ b15 = 0set @ b16 = 0set @ b17 = 0set @ b18 = 0set @ b19 = 0set @ b20 = 0
declare @xiaqu varchar (24) declare @current intdeclare @AllCount intset @ current = 1insert @tbtiqu (anbie, xiaqu, isxingshi) select anbie, xiaqu, isxingshi from tanjian where jiejingtime> @datetimeS and jiejingtime <@datetimeE
INSERT @TBXIAQU (XXIAQ) VALUES ('Pompong') Insert @TBXIAQ (XXIAQ) Values ('Pupix ") Insert @tbxiaqu (xxiaqu) VALUES (' Penzhuang ') Insert @tbxiaqu (xxiaqu) VALUES 'Annoying') Insert @tbxiaqu (xxiaqu) VALUES ('total tube') Insert @tbxiaqu (xxiaqu) Values ('Luogang ") Insert @tbxiaqu (xxiaqu) VALUES (' Meng Qiaqu ') Insert @TBXIAQU (xxiaqu) VALUES ('seed seedlings') Insert @TBXIAQU (XXIAQ) VALUES (' Wu Qiu ") Insert @tbxiaqu (xxiaqu) Values ('Zhao Di") Insert @tbxiaqu (xxiaqu) VALUES (' 佘 家") Insert @tbxiaqu (xxiaqu) Values ('Ding Yi') Insert @TBXIAQU (XXIaqu) VALUES ('Fangli') Insert @tbxiaqu (xxiaqu) VALUES ('Man Village') Insert @TBXIAQU (xxiaqu" ) VALUES ('Zhang Sanzhan') Insert @TBXIAQU (XXIAQ) Values ('All Phase "Insert @TBXIAQU (XXIAQ) Values (' Changcun ') Insert @tbxiaqu (xxiaqu) VALUES (' Zhang Zhan" ') set @allcount = (Select Top 1 Xid from @tbxiaqu orderer by xid DESC)
while @current <= @ AllCount begin set @xiaqu = (select xxiaqu from @tbXiaqu where xid = @ current) select @ a1 = count (*) from @tbtiqu where isxingshi = 1 and xiaqu = @ xiaqu select @ a2 = count ( *) from @TBTIQU WHERE Anbie in ('murder', 'hurt death') and xiaqu = @ xiaqu selection @ A3 = count (*) from @TBTIQU WHERE Anbie in ('robbery', 'snap ") and xiaqu = @ XIaqu Select @ a4 = count (*) from @TBTIQU where Anbie = 'Theft' and xiaqu = @ xiaqu select @ a5 = count (*) from @tbtiqu where anbie = 'Theft Motor Car' and xiaqu = @ xiaqu select @ a6 = count (*) from @TBTIQU where Anbie = 'rape' and xiaqu = @ xiaqu select @ a7 = count (*) from @TBTIQU where anbie = 'explosion' and xiaqu = @ xiaqu select @ a8 = count (*) from @TBTIQU Where Anbie = 'Introduction' and xiaqu = @ xiaqu select @ a9 = count (*) from @TBTIQU where Anbie = 'drug traffick' and xiaqu = @ xiaqu select @ a10 = @ A1 @ A2 @ A3 @ A4 @ A5 @ a6 @ a7 @ a8 @ a9
SELECT @ a11 = count (*) from @TBTIQU where Anbie = 'security case' and xiaqu = @ xiaqu select @ a12 = count (*) from @TBTIQU where anbie = 'public security disaster (accident)' and xiaqu = @ xiaqu select @ a13 = count (*) from @TBTIQU where anbie = 'fire alarm' and xiaqu = @ xiaqu select @ a14 = count (*) from @TBTIQU where anbie = 'traffic accident' and xiaqu = @ xiaqu selection @ a15 = count *) from @TBTIQU where anbie = 'other police love "and xiaqu = @ xiaqu select @ a16 = count (*) from @TBTIQU where anbie =' acceptance help 'and xiaqu = @ xiaqu select @ a17 = count (*) from @tbtiqu where anbie = and xiaqu = @ xiaqu select @ a18 = count and xiaqu = @ xiaqu select @ a19 = count 'advice provided' (*) from @tbtiqu where anbie = 'harassment' (*) from @tbtiqu where anbie = 'Other invalid alarm' and xiaqu = @ xiaqu select @ a20 = @ a10 @ a11 @ a12 @ a13 @ a14 @ a15 @ a16 @ a17 @ a18 @ a19
insert @tbResult (rxiaqu, xingHeji, sharen, qiangjie, daoqie, daoqieJ, qiangjian, baozha, toudu, fandu, xingQita, zhian, zaihai, huojing, shigu, Jqita, qiuzhu, zixuan, saorao, Wqita, zong) values (@xiaqu , @ a1, @ a2, @ a3, @ a4, @ a5, @ a6, @ a7, @ a8, @ a9, @ a10, @ a11, @ a12, @ a13, @ a14, @ a15, @ a16, @ A17, @ a18, @ a19, @ A20) set @ b1 = @ b1 @ a1 set @ b2 = @ b2 @ a2 set @ b3 = @ b3 @ a3 set @ b4 = @ b4 @ a4 set @ b5 = @ b5 @ A5 set @ b6 = @ b6 @ a6 set @ b7 = @ b7 @ a7 set @ b8 = @ b8 @ a8 set @ b9 = @ b9 @ a9 set @ b10 = @ b10 @ a10 set @ b11 = @ b11 @ a11 set @B12 = @ B12 @ a12 set @ b13 = @ B13 @ a13 set @ b14 = @ b14 @ a14 set @ b15 = @ b15 @ a15 set @ b16 = @ b16 @ a16 set @ b17 = @ b17 @ a17 set @ B18 = @ b18 @ a18 set @ b19 = @ b19 @ a19 set @ b20 = @ b20 @ a20set @ current = @ current 1end insert @tbResult (rxiaqu, xingHeji, sharen, qiangjie, daoqie, daoqieJ, qiangjian, baozha, toudu, Fandu, xingqita, zhian, zaihai, hujing, shigu, jqita, qiuzhu, zixuan, sarao, wqita, zong) VALUES ('total:', @ b1, @ b2, @ b3, @ b4, @ b5, @ b6, @ B7, @ b8, @ b9, @ b10, @ b11, @ b12, @ b13, @ b14, @ b15, @ b16, @ b17, @ b18, @ b19, @ b20) select * from @TBRESulTGO
