ALTER PROCEDURE dbo.totalStat
@areaCode int
AS
SET NOCOUNT ON
declare @condition varchar(2000) --查询条件
et @condition = '机构代码 in (select 机构代码 from v_机构代码表 where 地区代码 = ' + cast(@areaCode as varchar(6)) + ')'
ALTER PROCEDURE dbo.totalStat
@areaCode int
AS
SET NOCOUNT ON
declare @condition varchar(2000) --查询条件
et @condition = '机构代码 in (select 机构代码 from v_机构代码表 where 地区代码 = ' + cast(@areaCode as varchar(6)) + ')'