Ronda Pederson's Facebook profile

Showing entries for category SQL
<September 2010>
SMTWTFS
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789



RSS

Subscribe to the RSS feed for this blog.

Search


(single terms only)

Categories

  • RSS
  • RSS
  • RSS
  • RSS
  • RSS
  • RSS
  • RSS
  • RSS
  • RSS
  • Quote

    A little inaccuracy sometimes saves a ton of explanations.
    —Anon.

    Blogs I Read

    Links




    Fun

     
       |  SQL Dupes
    [ | ]

    I saw a post on one of my lists today for retrieving only duplicate records and it reminded me of how valuable Pentons article has been to me over the years.
    One of the issues we almost always encounter when dealing with other peoples data (it could not happen to us directly because we always have excellent DB design) is dealing with duplicate records. David Pentons 'analyzing duplicate records' script is too lengthy to paste here but check it out when you get a chance: Analyzing Duplicate Records

    posted at 12:06 PM | [1] |