Oyuna Girmeyen Karakterleri Silme

delete userdata where updatetime < '2012-01-01 01:00:00' and   loyalty < 10000

CREATE PROCEDURE [temizlik1]
--@AccountID    varchar(21)
AS
SET NOCOUNT ON
DECLARE @AccountID varchar(21)
DECLARE @m1 char(21), @m2 char(21), @m3 char(21), @s1 tinyint, @s2   tinyint, @s3 tinyint, @c1 char(21), @c2 char(21), @c3 char(21), @r1   tinyint, @r2 tinyint, @r3 tinyint,@u char(21)
SET @r1=0
SET @r2=0
SET @r3=0
SET @s1=0
SET @s2=0
SET @s3=0
SET @c1=null
SET @c2=null
SET @c3=null
DECLARE job1 CURSOR FOR
Select straccountid from Account_char
OPEN job1
FETCH NEXT FROM job1
INTO @AccountID
WHILE @@fetch_status = 0
BEGIN
SELECT @c1 = strcharid1, @c2 = strcharid2, @c3 = strcharid3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
SELECT @r1=count(struserid) FROM [dbo].[USERDATA] WHERE strUserId=@c1
IF @r1=0
UPDATE ACCOUNT_CHAR set strcharid1=null where strAccountID = @AccountID
SELECT @r2=count(struserid) FROM [dbo].[USERDATA] WHERE strUserId=@c2
IF @r2=0
UPDATE ACCOUNT_CHAR set strcharid2=null where strAccountID = @AccountID
SELECT @r3=count(struserid) FROM [dbo].[USERDATA] WHERE strUserId=@c3
IF @r3=0
UPDATE ACCOUNT_CHAR set strcharid3=null where strAccountID = @AccountID
SELECT @m1 = strcharid1, @m2 = strcharid2, @m3 = strcharid3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
select @s1=count(struserid) from [dbo].[USERDATA] where strUserId=@m1
select @s2=count(struserid) from [dbo].[USERDATA] where strUserId=@m2
select @s3=count(struserid) from [dbo].[USERDATA] where strUserId=@m3
update account_char set bcharnum=@s1+@s2+@s3 where strAccountID=@AccountID
    FETCH NEXT FROM job1
    INTO @AccountID
END
CLOSE job1
DEALLOCATE job1
SET NOCOUNT OFF
GO

delete account_char where strcharid1 is null and strcharid2 is null and strcharid3 is null
delete tb_user where straccountid not in (select straccountid from account_char)
delete warehouse where straccountid not in (select straccountid from  tb_user)