Re: grouping data on weekly basis

Tech-Archive recommends: Fix windows errors by optimizing your registry

Check whats the PK (probably date). Perhaps you started the script twice or
something?


MC

"preet" <preetkanwaljit> wrote in message
news:u0iC%23PJhHHA.4516@xxxxxxxxxxxxxxxxxxxxxxx
I get the following error on step 2 above

1 row(s) affected)

Server: Msg 2627, Level 14, State 1, Line 5
Violation of PRIMARY KEY constraint 'PK_BusinessCalendar'. Cannot insert
duplicate key in object 'BusinessCalendar'.
The statement has been terminated.
Server: Msg 2627, Level 14, State 1, Line 5
Violation of PRIMARY KEY constraint 'PK_BusinessCalendar'. Cannot insert
duplicate key in object 'BusinessCalendar'.
The statement has been terminated.




--------------------------
My websites
http://www.eecpworld.com/
http://www.jungle-forex.com/


*** Sent via Developersdex http://www.developersdex.com ***


.

Relevant Pages

  • Re: Return SQL Server Error Msg
    ... Cannot insert duplicate key in ... > Violation of PRIMARY KEY constraint 'PK_Stages'. ... how could I return the error msg returned by SQL Server? ...
    (microsoft.public.sqlserver.programming)
  • Re: Error 12005 in MSP 2007
    ... Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. ... insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'. ... RunBehavior runBehavior, String resetOptionsString) ...
    (microsoft.public.project)
  • Error 12005 in MSP 2007
    ... Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. ... insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'. ... RunBehavior runBehavior, String resetOptionsString) ...
    (microsoft.public.project)
  • Merge & delete
    ... Violation of PRIMARY KEY constraint ... Cannot insert duplicate key in object ... I need to find out why this is getting to my subscriber first - ...
    (microsoft.public.sqlserver.replication)
  • Replication Primary Key Error when inserting into a couple of tables
    ... Violation of PRIMARY KEY constraint 'PK_ConstraintName'. ... insert duplicate key in object ... Transaction sequence number and command ID of last execution batch are ...
    (microsoft.public.sqlserver.replication)