Stil the same error with the GROUP BY...

Assuming that both the view and the sp are specific to this process, which is extracting new clients from the bargains table and...

Same error with this INSERT:

Msg 2627, Level 14, State 1, Line 2

Violation of PRIMARY KEY constraint 'PK_tblClients'.

Cannot insert duplicate key in object 'dbo.tblClients'.

The statement has been terminated.

Can I email...

Even If i could create a Macro button which when clicked prompts the user....

Chris, thats fantastic, thank.

BUT....:angry:

Now when I run my SP which calls this View I get the following error:

(Error from Job History)

Message

Executed as user: UK\SQLAdmin. Microsoft (R) SQL Server Execute Package...

Excel 2003 SP2

Thanks for the update.

Question is why was it working correctly in SQL2000 and now iv moved the DB to 2005 this error occurs?

Thank you very much

You are correct it has been asked before but the issue has progressed!!

I am asking where is it best to change the DataType??

In the View or in the Table?

Seem to have the same result....

32212

32212

Client_Short_Name nvarchar(30)

Client_Long_Name nvarchar(100)

UK ...

I am very sorry, that was the incorrect INSERT statement!!

Here is the correct one, the column types in my frst post relate to this INSERT:

INSERT INTO dbo.tblClients

(Client_Short_Name,

Client_Long_Name,

CountryCode,

ClientID)

SELECT dbo.vwImportAllNewClientIDs.Client, dbo.vwImportAllNewClientIDs.Client,...

Ok I think I have now included some more helpful information.

I have attched:

- 'Bargains' tables colums & data types

- 'procImportAllFiles' SP in fill (saved as a .txt but can be...

My gut feeling without looking at the data tells me you my have more than a one to one relationship between the tables Bargains and tblStocks. I'd start by...

Ok getting the following error when running the update:

Msg 8152, Level 16, State 4, Line 1

String or binary data would be truncated.

The statement has been terminated.

Sorry, what did you mean by the bit of code:

DECLARE @Client VARCHAR(255)

SET @Client = 'This is a 30-char client name.Here are another thirty chars.'

Chris thats fantastic, I cant thank you enough!

I willm try this and keep toy posted:

Drop tblclients

Create NEW tblclients

Edit SP with new INSERT

RUN SP