Post reply

Whats wrong with DISTINCT in this query?

  • June 24, 2008 at 11:02 am

    #833470

    steveb (6/24/2008)

    but you are selecting a lot of other fields

    What Steve has said there is the sum of it... DISTINCT operates on all of the fields you list, not just the one to come after the word. If ANY of those fields are text or binary type blobs... you can't use DISTINCT or GROUP BY in the query.


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply