SELECT *

FROM Temp_BigTable

WHERE SSN + PKT + FICE_NBR

NOT IN (

SELECT SSN + PKT + FICE_NBR

FROM shi.raw33

)

The SSN is stored as a MD5 hashed value.

The combination of SSN, PKT and FICE_NBR in table A does not have a match on the combination of SSN, PKT and...

The SSN is stored as a hashed value.

I forgot to mention that I need to exclude duplicate rows from the result set.

Thanks.

Thank you all for your replies. I have implemented this and it is working great!

Thanks. I am all set.

Forgive my ignorance, as this is something new for me.

I performed a backup of a database consisting of a single mdf and ldf (the backup file has a .bak extension).

I...

I am the only user that does inserts / updates/ deletes to the table.

All of the other users can only do SELECTs against the table....so this means that I can...

So if I am the owner of the table, can I drop it even if users are trying to query against it?

If I can't drop it in this case, how...

Lynn's code worked! Thanks Lynn. Consider this topic closed.

Thank you all for your posts. I believe that I have all of the information that I need to proceed. You may consider this topic closed.

No. Now that I understand this I don't care how the data is stored.

Again, thank you all for your responses. You may consider this closed.

Thank you for your responses. Your help is greatly appreciated.

There actually is a clustered index on the TIME_STAMP column, and as you saw in the insert statement in my post I am using an ORDER_BY. So what you...

Perfect! That worked. Thank you so much.