Home Forums SQL Server 2008 T-SQL (SS2K8) How to determine which items in one table do not appear in a second table RE: How to determine which items in one table do not appear in a second table

  • December 20, 2012 at 10:23 pm

    #1570715

    Melanie Peterson (12/20/2012)

    Thank you, Vinu! The EXCEPT statement is new to me. Always nice to learn something new.

    Yes it is always good to learn something new Melanie.

    And what is even better is getting to know how to do things the right way. So, if this is not a one time requirement then I would recommend that you do a small test to get to know which of the above two solutions is better performance wise on a bigger set of data and use that one.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉