CREATE PROCEDURE WZ_DISCONNECT_MEMB @memb___id varchar(10) AS Begin set nocount on Declare [USER=1333416677]Find[/USER]_id varchar(10) Declare [USER=1333459481]Connects[/USER]tat tinyint Set [USER=1333459481]Connects[/USER]tat = 0 Set [USER=1333416677]Find[/USER]_id = 'NOT' select [USER=1333416677]Find[/USER]_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id where I.memb___id = @memb___id if( [USER=1333416677]Find[/USER]_id <> 'NOT' ) begin update MEMB_STAT set ConnectStat = [USER=1333459481]Connects[/USER]tat, DisConnectTM = getdate(), OnlineHours = OnlineHours+(DATEDIFF(hh,ConnectTM,getdate())) where memb___id = @memb___id -- TIMEONLINE MOD by john_d end end GO