You are here: Re: Simple SQL Distinct...!? « MsSQL Server « IT news, forums, messages
Re: Simple SQL Distinct...!?

Posted by @sh on 02/27/06 18:38

I totally agree and by offering them the latest address that matches the
address to which they're sending, a new one wouldn't be inserted, I'd pass
that DID (DeliveryID) on for use with order.

Is there a way to get the DID into the query too?

Cheers, Ash


<markc600@hotmail.com> wrote in message
news:1141055631.655033.148880@v46g2000cwv.googlegroups.com...
>
> As David has already mentioned, you would be
> better off fixing this to prevent duplicates
> appearing in the first place. Picking the
> latest address using the highest DeliveryID
> will probably work (assuming this is an identity),
> but you are filling your table with redundant
> data - not good in the long term.
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация