Re: DISTINCT

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: J (anonymous_at_discussions.microsoft.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 13:40:12 -0700

It doesn't matter which one I get as long as I don't get
the same person twice, my requirements have actually
changed and I will going back to get the other information
later. I'm performing data migration from this source
system over to an enterprise oriented database.

>-----Original Message-----
>> The problem I was having before was not having the
ability
>> to select distinct on a couple of columns as well as
>> returning the rest of the related columns without the
>> distinct used on them. So I just concatenated a few
>> columns together within the distinct clause and left
>> everything else outside of it.
>
>This is an inelegant and non-relational solution at best,
and will probably
>perform terribly as well. Let's ask my first question
again.
>
> If you have two rows:
>
>APP_NO FirstName LastName Sin Birthdate
>5 Bob Jones 111-11-1111 19740201
>12 Bob Jones 111-11-1111 19740201
>
>Which row do you want?
>
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>
>.
>

Relevant Pages

  • Re: Curvature vs matter by KST
    ... it does not matter if he has the ability or not. ... here is the derivation of the field equations. ... the Lagrangian which does not even satisfy as a Lagrangian according ...
    (sci.physics.relativity)
  • Re: evolutionary dead end?
    ... and transcendence in public solitude. ... the ability to be fully aware of and present to the matter at hand. ... I had the bank wire me the money and he had the guitar ready for me. ...
    (rec.music.classical.guitar)
  • Re: Curvature vs matter by KST
    ... it does not matter if he has the ability or not. ... here is the derivation of the field equations. ... the Lagrangian which does not even satisfy as a Lagrangian according ...
    (sci.physics.relativity)
  • Re: Tom Porterfield MS-MVP?
    ... No one has the ability to rearrange the order ... People with original ideas, no matter how large or small, should ... be given credit where credit is due. ... And, if I look foolish, so be it. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Dear Other Professor Dudes
    ... I've wondered if the ability to ask without being face-to-face ... You know, I was on the other side once or twice, too. ... Saved my scholarship at the ...
    (rec.sport.football.college)