1. GeniusConnect support
  2. Database
  3. MS SQL Server
  4. No Primary Key
Guest
2014-01-23T13:20:00Z
Hi,

We are using GeniusConnect to import SQL Server Contact data to a Shared Outlook Contact Folder.

We are using a View collecting data from multiple tables, problem is there is no Primary Key / Column for unique identification of a row in the result set.
Also we are getting duplicate rows. Any Ideas ?

Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2014-01-23T13:24:00Z
Hello,

you can use DISTINCT to eliminate duplicate rows, and create a dummy key with for example CHECKSUM , example :

SELECT DISTINCT LastName, FirstName, Email, CHECKSUM(LastName + FirstName + Email) AS DummyKey
 Atom Feed Rss Feed
Similar Topics
  1. GeniusConnect support
  2. Database
  3. MS SQL Server
  4. No Primary Key