Query
Code:SELECT al.CharID, uwc.UserJID FROM SRO_VT_SHARD.dbo._User uwc LEFT JOIN SRO_VT_SHARD.dbo._Char al ON uwc.CharID = al.CharIDWHERE LastLogout < '2014-05-22 23:59:59' AND Deleted=0 AND CurLevel <111 UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [Deleted] = 1 WHERE LastLogout < '2014-05-22 23:59:59' AND Deleted=0 AND CurLevel <111
Video guide :



Reply With Quote

