T-SQL, any ideas?

[wizzo]

Hello nerdy friends of mine. Anyone know if there an inherent difference to the following select statements?

select * from where SessionID NOT IN (select SessionID from tmpsys_Log with (NOLOCK) where LogLevel = 10)

as opposed to:

select * from where SessionID IN (select SessionID from tmpsys_Log with (NOLOCK) where LogLevel <> 10

Comments

[xspliffx]

ah you beat me to it. i had gone out for a smoke to contemplate it, then grabbed coffee...

glad you figured it out though. ;)

[hellagoodstar]

HOLY SHIT.
i must not be nerdy :)