Ya...
Show your query so that we can judge?

Regards,

Carolin Divya.K,
Cognizant technologies,
Chennai.
When I was young, I used to admire intelligent people; as I grow older,
I admire kind people. Abraham Joshua Heschel


-----Original Message-----
From: Damir Sultanbekov
[mailto:mssqldba-ezmlmshield-x85186732.[Email address protected]
Sent: Friday, August 31, 2007 2:49 PM
To: LazyDBA Discussion
Subject: Re: Select Distinct Values

Could you show us your query?

Carel Greaves wrote:

>Just a question
>
>
>
>I have a query that selects profile data for members, if I don't do a
select
>distinct it gives me a lot of correct values, (unique values) of
members
>i.e. only one record per member, but every now and then I get duplicate
>values for one member, multiple times.
>
>
>
>Why does this occure?
>
>
>
>I know SELECT DISTINCT is there to remove duplicates, but without
SELECT
>DISTINCT why would this "mistake" happen?
>
>
>
>Any help would be greatly appreciated.
>
>



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.

MS Sql Server LazyDBA home page