I execute the following Query:

INSERT INTO POSTAL (ID,Latitude, ID.Longitude, CityTownshipID, CountyRegionID,StateProvinceID,CountryID)

SELECT ZipCode, Latitude, Longitude,CityTownshipID , CountyRegionID, StateProvinceID, CountryID

FROM Postal_Codes_Import

WHERE NOT EXISTS (SELECT *

...

Phil Parkin (1/14/2016)

---

The WHERE NOT EXISTS () construction often performs better than using a LEFT JOIN – I would recommend a test.

You should include table schemas in your code to...

Yes there are 3 duplicates when I do a INNER JOIN but I exclude them in the Insert and I keep getting PK Violations. :unsure:

Perhaps a Data Type issue?

Table Structure:

CREATE TABLE [dbo].[Postal](

[ID] [varchar](16) NOT NULL,

[Latitude] [float] NOT NULL,

[Longitude] [float] NOT NULL,

[CityTownshipID] [int] NOT NULL,

[CountyRegionID] [int] NULL,

[StateProvinceID] [int] NOT NULL,

[CountryID] [int] NOT NULL,

CONSTRAINT [PK_Postal]...

That is correct.

I'm trying...

Phil Parkin (1/14/2016)

---

The WHERE NOT EXISTS () construction often performs better than using a LEFT JOIN – I would recommend a test.

You should include table schemas in your code to...

The ZipCode is named ID.

That would help if I included the error. :blush:

Violation of PRIMARY KEY constraint 'PK_Postal'. Cannot insert duplicate key in object 'dbo.Postal'. The duplicate key value is (B5A 5B4).

I recall using SSMS and electing the Full Backup file, the latest differential and manually selecting all of the Transaction Log Backups.

I do not remember the steps that I took...

Thanks for the link but I could not find what I was looking for.

Happy New Year.

Is this not the same as what was recommended in the...

JeremyE (12/29/2015)

---

From the error, it sounds like an issue with the publisher database's owner (missing, invalid, etc.).

Check to see if the publisher database has a valid owner by running the...

Your code is very cleaver and the other post that were...

I very much appreciate all of the help.

I'm only dealing with 50,,, records.

When I performed the archive I had a lookup table that stored the Batch Size etc.

Can I do...

Ed Wagner (12/28/2015)

---

I would start by verifying the rows you want to delete like this. You didn't post the DDL, so I don't have your column list. You'll...