Browse by Tags

Sorry, but there are no more tags available to filter with.
New MSDN SQL Server Wiki
The Volunteer Moderators and Answerers who support the Microsoft MSDN SQL Server Forums have created a new wiki to present Solutions to Common T-SQL Problems at http://code.msdn.microsoft.com/SQLExamples . At the moment mere mortals can't update the...
Posted 17 April 2008 11:35 AM by jonsayce | with no comments
Filed under:
Using ...WHERE NOT IN (SELECT... with NULLs
I was asked to look at a query today and explain why using a NOT IN clause wasn't returning any rows. Switching the NOT IN to an IN resulted in 38 rows, and removing the clause completely returned 431 rows. So what was happening to the other 393? Surely...
Posted 03 December 2007 11:38 AM by jonsayce | with no comments
Filed under: