Posted by Erland Sommarskog on 07/20/07 21:26

pbd22 (dushkin@gmail.com) writes:
> I am wondering if we are talking about the same "SELECT DISTINCT"?

Yes, we are. The point of my philosophical discussion was that you
should get rid of the duplicates by writing your joins better or
refine the data model.

But as I still don't know what your query is supposed to achieve, I can't
really say how you would do that.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Problem with nested function call (UDFs)
• Prev in forum: Re: Import from MSSQL2000 (8) to 7?
• Thread view: Re: Establishing Precedence In ORDERBY Condition Causing Problems.

[Reply to this message]