Posted by pbd22 on 07/20/07 23:39

On Jul 20, 2:26 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> pbd22 (dush...@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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Hi Erland,

Thanks. I have sent you an email. I'll check back here for a
continuation of the thread.

Thanks again.

• Next in forum: Re: Trigger After Delete - I need a Trigger Before Delete
• Prev in forum: Re: Trigger After Delete - I need a Trigger Before Delete
• Thread view: Re: Establishing Precedence In ORDERBY Condition Causing Problems.

[Reply to this message]