存储过程带有参数返回值和游标的

USE [YunNanHw]
GO
/****** Object:  StoredProcedure [dbo].[EventReport]    Script Date: 06/07/2018 08:47:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 ALTER proc [dbo].[EventReport]
  (
  @cusID nvarchar(50),
  @adminid nvarchar(50)
  )
  as
  begin
  declare @departID nvarchar(50);
  declare @departname nvarchar(50);
  declare @ChaoQi int;
  declare @ShangBao int;
  declare @WanCheng int;
  declare @ChuLi int;
  declare @SOS int;
  declare @retention int;
  declare @electricity int;
  declare @Transboundary int;
  declare @str nvarchar(max);
  
  select @str=dbo.SQLDataPowerFilter(@adminid)
  
  ----正确的临时表删除操作
if object_id('tempdb..#aa') is not null Begin
    drop table #aa
    drop table #tt
End
  
  CREATE TABLE #tt(
  [DepartID] [nvarchar](50) NOT NULL,
	[DepartName] [nvarchar](200) NOT NULL,
	[ChaoQi] [int] NULL,
	[ShangBao] [int] NULL,
	[WanCheng] [int] NULL,
	[Ch