SQL Query to Delete ALL Empty Accounts ?

Hi guys maybe some one got > SQL Query to Delete ALL Empty Accounts ?


Thank you :)

Code:

---

DELETE FROM SRO_VT_ACCOUNT.dbo.TB_User WHERE JID NOT IN (SELECT DISTINCT JID FROM SRO_VT_SHARD.dbo._User)

---

dunno if there will be any conflict, havent tried, let me know if there was, dont forget to back up your databases

Quote:

---

Originally Posted by sladlejrhfpq

Code:

---

DELETE FROM SRO_VT_ACCOUNT.dbo.TB_User WHERE JID NOT IN (SELECT DISTINCT JID FROM SRO_VT_SHARD.dbo._User)

---

dunno if there will be any conflict, havent tried, let me know if there was, dont forget to back up your databases

---

(0 row(s) affected)


dosen't working :P ....

thanks for try :)

sorry my mistake

Code:

---

DELETE FROM SRO_VT_ACCOUNT.dbo.TB_User WHERE JID NOT IN (SELECT DISTINCT UserJID FROM SRO_VT_SHARD.dbo._User)

---

try now ^^

(10190 row(s) affected)


Thanks bro ! :)


Do you have maybe too ...


Chars that was not used some days or months :P ... ?

Thanks again....

I don't have, that would be a bit harder, because the _Char table have too much dependencies, maybe I'll do it when I'm bored ^^