Shulou(Shulou.com)06/01 Report--

USE [EFNETSYS]GO/** **** Object: StoredProcedure [dbo]. [SP_Dz] Script Date: 05/26/2018 16:14:10 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROCEDURE [dbo]. [SP_Dz]( @Logout time int = 360) ASBEGIN SET NOCOUNT ON; --------------------------------------------------------------if object_id('tempdb..# TempA') is not null drop table #TempA; -------------------------------------------------------------- DECLARE @Time nchar(20) = replace(Convert(nchar(20),GETDATE(),120),'-','/') DECLARE @Run_Time_ss int , @XUHAO varchar(8) set @Run_Time_ss = Convert(int,substring(@Time,18,2)) + Convert(int,substring(@Time,15,2)) * 60 + Convert(int,substring(@Time,12,2)) * 360 select * into #TempA from (select ROW_NUMBER () OVER (ORDER BY@XUHAO ASC) AS 'Sequence number' ,* from (select ZZ 001 as Registrant , ZY 002 as Start time ,@Time as Current Time ,@Run_Time_ss - ( Convert(int,substring(ZY002,18,2)) + Convert(int,substring(ZY002,15,2)) * 60 + Convert (int, substring (ZY 002, 12, 2))* 360) as Runtime , ZZ 004 from EFNETSYS. dbo. CRMZZleft join EFNETSYS. dbo. CRMZZYon ZZ 001 = ZY 001 and ZZ 004 = ZY 004) as Awhere runtime>@logout time) as B--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ,@rows int = (select COUNT(*) from #TempA) ,@ZZ004 nchar(20)if @rows 0begin while @i

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.