Home Forums SQL Server 2005 SQL Server 2005 General Discussion Help reqd for eliminating a similar IDs- Query RE: Help reqd for eliminating a similar IDs- Query

  • April 24, 2008 at 4:26 am

    #806450

    select * from myTable where BatchID not in (select BatchID from myTable where Status = 'Rework')

    Ryan Randall

    Solutions are easy. Understanding the problem, now, that's the hard part.