Duplicate issue. (1 Viewer)

User Name:

Registered User.
Local time
Today, 15:39
Joined
Jun 29, 2013
Messages
17
Hi everyone,

I have a sql dbo qry that extracts data from a server, I then have a qry aligns that data to a hierarchy then saved that data to a tbl which is linked to a sharepoint site.

The problem I have is I want the process to ensure any duplicates are removed before it saves the data to the tbl which links to the sharepoint.

Can anyone suggest anything to help?

Thanks

UN
 

CJ_London

Super Moderator
Staff member
Local time
Today, 15:39
Joined
Feb 19, 2013
Messages
16,553
It depends on what is defined as a duplicate but the usual way to do this is to use

SELECT DISTINCT * FROM myTable

Alternatively you can GROUP the data and use First/Last/Min/Max etc to bring through what you require
 

Users who are viewing this thread

Top Bottom