well i wrote it like this right now

DELETE FROM [CHARACTER_01_DBF].[dbo].GUILD_MEMBER_TBL WHERE NOT EXISTS (SELECT (m_idPlayer) COLLATE DATABASE_DEFAULT FROM [LOGGING_01_DBF].[dbo].[LOG_LOGIN_TBL])

hopefully this will be better

and about the loop thing i dont...

CapnHector (2/27/2013)

---

Since you have multiple tables using the same exclusion data set i would create a work table with that data set and index it, then use a LEFT JOIN...

homebrew01 (2/27/2013)

---

In general, when I have a lot of rows to delete, I do it in a loop with a "wait". The advantages for me are:

Small chunks so I...

CapnHector (2/27/2013)

---

thats what i mean by sub query.

However how many rows are in the logging table and what indexes there are will affect this a lot. Also is End_Time...

by sub query u mean WHERE End_Time > '20130123015613' right ?

this means it will delete all data that is below 2013/23/01/01:56:03

year day month hour minute second format

and that sub query...

DELETE FROM [CHARACTER_01_DBF_OLD].[dbo].CHARACTER_TBL WHERE m_idPlayer NOT IN (SELECT DISTINCT(m_idPlayer) COLLATE DATABASE_DEFAULT FROM [LOGGING_01_DBF].[dbo].[LOG_LOGIN_TBL])

this query should delete all the m_idplayers that dont appear in the LOG_LOGIN_TBL right ?

133.723 rows total and i wanna keep 77.646

i wanna delete the custom amount according to the query u see above but i tried to run a count for the remaining...