select fsl_choId, companyName, address, city, state, zipcode, mfrCustNum, count( operatorId ) from tbl_OPR_ClientOperators with (nolock) where ownerId = 4036 and fsltablecode = 'DST' and nullif( mfrCustNum, '' ) is not null and nullif( fsl_choId, 0 ) is not null group by fsl_choId, companyName, address, city, state, zipcode, mfrCustNum having count( operatorId ) > 1 select operatorId from tbl_OPR_ClientOperators opr with (nolock) where ownerId = 4036 and fsltablecode = 'DST' and fsl_choId = and companyName = and address = and city = and state = and zipcode = and mfrCustNum = order by opr.crmActive desc, opr.dateCreated desc