Posted by markc600 on 09/14/06 20:21

SELECT CUSTOMER_NUMBER
FROM MyTable
GROUP BY CUSTOMER_NUMBER
HAVING COUNT(DISTINCT BUSINESS_UNIT_ID)>1

• Next in forum: sql server i/o bottle neck ?
• Prev in forum: For SQL Buffs
• Thread view: Re: For SQL Buffs

[Reply to this message]