Jump to content

rkemunto

Members
  • Posts

    2
  • Joined

  • Last visited

Everything posted by rkemunto

  1. rkemunto

    DATEPART

    Does anyone know how I can plug in 01/31/2006 into datepart below:Select RTRIM(CONVERT(Char(01),DATEPART(month,GETDATE())))+"/"+RTRIM(CONVERT(Char(01,)DATEPART(day,GETDATE())))+"/"+RTRIM(CONVERT(Char(2006),DATEPART(year,GETDATE())))
  2. I am researching on how to eliminate duplicate records entering into our database and would appreciate any input. If anyone has a strategy in place that works for them, I'd also love to know about it too.Data entry into our database is done via:1. Web users - by registering and creating their own user Id and Password (email is their userID) This data updates the persons, web user and company tables automatically.2. Manual Data entry from paper3. Imports from our List Vendors.4. Company recordScenario (a) If a person from (1) above changes companies, their email addresses changes and instead of logging into the web account using previous email address, then changing account info - instead they ignore the step and create a new account user with their new email address which creates a duplicate record in the database. Scenario ( if one forgets their password - instead of contacting the webmaster to retrieve their old password, they create a new userid (using a different email address) and a new user ID. This creates another record in the database.Scenario © If the person's records exists with our list supplier but with different email address, although the database compares, last names, company etc - it still creates a duplicate record because of the different email address for that person.Our database is composed of members (from persons table - email is Primary Key) from different organizations (from company table - company website is primary Key) and have access to our products on our web site (from Web User table - email is unique key). Anyone knows of a better way to aleviate dups e.g by a different key for web registrants.How should I correct the many dups we already have in the database ( over 20,000 records)I appreciate your input on this.
×
×
  • Create New...