In many cases, "NOT IN" takes a lot of time. If the table has key column, I suggest following steps. 1. Insert key value, to be filtered, into temporary table. 2. Query with "NOT EXISTS" like "select .. from table where not exists ( select ... temporary_table where table.key = temporary_table.key )"

ToshiyaTSURU turutosiya@gmail.com http://www.google.com/profiles/turutosiya

int.Parse(str)

ToshiyaTSURU turutosiya@gmail.com http://www.google.com/profiles/turutosiya

Also, this tool may be helpful. http://technet.microsoft.com/en-us/sysinternals/bb896652.aspx[^]

ToshiyaTSURU turutosiya@gmail.com http://www.google.com/profiles/turutosiya