getting dublicated primary key

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

getting dublicated primary key

Author

Topic

jonas85
Starting Member

3 Posts

Posted - 2010-10-10 : 15:59:03

i get alot of dublicated primary key conflcit but the issue is i dont know what else to do because 30000 for projektledare is the salary and 25000 is for the it arkitekt how can i combine that coding :S
Pulsen is the primary key here.

VALUES('Pulsen',
'Projektledare',
CONVERT(DATETIME, '2010-10-05 00:00:00.000', 121),
CONVERT(DATETIME, '2010-12-24 00:00:00.000', 121),
'Projektledare',
'30000')

VALUES('Pulsen',
'IT-arkitekt',
CONVERT(DATETIME, '2010-11-15 00:00:00.000', 121),
CONVERT(DATETIME, '2011-02-01 00:00:00.000', 121),
'Systemarkitekt',
'25000')

jonas85
Starting Member

3 Posts

Posted - 2010-10-10 : 15:59:41

here is the rest of the coding

--Formedlare
INSERT formedlare
(formnr,
namn,
rumsnr)
VALUES('F0005',
'Lennart Värmare ',
'3')

INSERT formedlare
(formnr,
namn,
rumsnr)
VALUES('F0012',
'Clara Klang ',
'10')

INSERT formedlare
(formnr,
namn,
rumsnr)
VALUES('F0032',
'Ulla Grenås ',
'12')

GO

--Foretag
INSERT foretag
(ftgnamn,
antalanstallda,
verksamhet,
adress,
postnr,
ort)
VALUES('ICA Nara Ljung',
'640',
'Dagligvaruhandel',
'stationsvagen 3',
'52496',
'Ljung')

INSERT foretag
(ftgnamn,
antalanstallda,
verksamhet,
adress,
postnr,
ort)
VALUES('Manpower',
'270',
'IT',
'Graddgrand',
'50250',
'Boars')

INSERT foretag
(ftgnamn,
antalanstallda,
verksamhet,
adress,
postnr,
ort)
VALUES('Pulsen',
'300',
'IT',
'Glasgatan 15',
'50155',
'Boars')

INSERT foretag
(ftgnamn,
antalanstallda,
verksamhet,
adress,
postnr,
ort)
VALUES('TA',
'230',
'VVS',
'Dammotet 1',
'52496',
'Ljung')

GO

--Sokande
INSERT sokande
(sokarnr,
formnr,
namn,
adress,
postnr,
ort)
VALUES('10',
'F0005',
'Anna Svensson ',
'Apelvägen 32 ',
'50190',
'Borås')

INSERT sokande
(sokarnr,
formnr,
namn,
adress,
postnr,
ort)
VALUES('12',
'F0005',
'Anders Carlsson ',
'Trailergränd 2',
'52496',
'Ljung')

INSERT sokande
(sokarnr,
formnr,
namn,
adress,
postnr,
ort)
VALUES('13',
'F0012',
'Björn Demidov ',
'Dostojevskigatan 27 ',
'50155',
'Borås')

INSERT sokande
(sokarnr,
formnr,
namn,
adress,
postnr,
ort)
VALUES('15',
'F0032',
'Catarina Alvhage ',
'Ekstigen 2 ',
'51783',
'Bollebygd')

GO

--Ansokan
INSERT ansokan
(ftgnamn,
erbjnamn,
sokarnr,
intervjutidpunkt,
inlamnad,
loneansprak)
VALUES('ICA Nära Ljung',
'Butiksbiträde',
'12',
CONVERT(DATETIME, NULL, 121),
CONVERT(DATETIME, '2010-09-13 00:00:00.000', 121),
NULL)

INSERT ansokan
(ftgnamn,
erbjnamn,
sokarnr,
intervjutidpunkt,
inlamnad,
loneansprak)
VALUES('ICA Nära Ljung',
'Kassamedarbetare',
'12',
CONVERT(DATETIME, NULL, 121),
CONVERT(DATETIME, '2010-08-25 00:00:00.000', 121),
NULL)

INSERT ansokan
(ftgnamn,
erbjnamn,
sokarnr,
intervjutidpunkt,
inlamnad,
loneansprak)
VALUES('Manpower',
'Projektledare',
'10',
CONVERT(DATETIME, NULL, 121),
CONVERT(DATETIME, '2010-09-17 00:00:00.000', 121),
NULL)

INSERT ansokan
(ftgnamn,
erbjnamn,
sokarnr,
intervjutidpunkt,
inlamnad,
loneansprak)
VALUES('Manpower',
'Projektledare',
'15',
CONVERT(DATETIME, '2010-10-06 00:00:00.000', 121),
CONVERT(DATETIME, '2010-09-07 00:00:00.000', 121),
'35000')

INSERT ansokan
(ftgnamn,
erbjnamn,
sokarnr,
intervjutidpunkt,
inlamnad,
loneansprak)
VALUES('Manpower',
'Systemutvecklare',
'13',
CONVERT(DATETIME, NULL, 121),
CONVERT(DATETIME, '2010-09-07 00:00:00.000', 121),
NULL)

INSERT ansokan
(ftgnamn,
erbjnamn,
sokarnr,
intervjutidpunkt,
inlamnad,
loneansprak)
VALUES('Manpower',
'Webbutvecklare',
'13',
CONVERT(DATETIME, '2010-12-20 00:00:00.000', 121),
CONVERT(DATETIME, '2010-09-01 00:00:00.000', 121),
'23000')

INSERT ansokan
(ftgnamn,
erbjnamn,
sokarnr,
intervjutidpunkt,
inlamnad,
loneansprak)
VALUES('Pulsen',
'Ekonom',
'10',
CONVERT(DATETIME, NULL, 121),
CONVERT(DATETIME, '2010-10-05 00:00:00.000', 121),
'27000')

INSERT ansokan
(ftgnamn,
erbjnamn,
sokarnr,
intervjutidpunkt,
inlamnad,
loneansprak)
VALUES('Pulsen',
'IT-arkitekt',
'13',
CONVERT(DATETIME, '2010-11-26 00:00:00.000', 121),
CONVERT(DATETIME, '2010-09-08 00:00:00.000', 121),
NULL)

INSERT ansokan
(ftgnamn,
erbjnamn,
sokarnr,
intervjutidpunkt,
inlamnad,
loneansprak)
VALUES('Pulsen',
'Projektledare',
'10',
CONVERT(DATETIME, NULL, 121),
CONVERT(DATETIME, '2010-09-18 00:00:00.000', 121),
NULL)

INSERT ansokan
(ftgnamn,
erbjnamn,
sokarnr,
intervjutidpunkt,
inlamnad,
loneansprak)
VALUES('Pulsen',
'Projektledare',
'15',
CONVERT(DATETIME, NULL, 121),
CONVERT(DATETIME, '2010-09-10 00:00:00.000', 121),
'34000')

INSERT ansokan
(ftgnamn,
erbjnamn,
sokarnr,
intervjutidpunkt,
inlamnad,
loneansprak)
VALUES('TA',
'Ekonom',
'10',
CONVERT(DATETIME, '2010-11-15 00:00:00.000', 121),
CONVERT(DATETIME, '2010-09-02 00:00:00.000', 121),
'23000')

INSERT ansokan
(ftgnamn,
erbjnamn,
sokarnr,
intervjutidpunkt,
inlamnad,
loneansprak)
VALUES('TA',
'Maskinist',
'12',
CONVERT(DATETIME, NULL, 121),
CONVERT(DATETIME, '2010-10-03 00:00:00.000', 121),
NULL)

GO

--Jobberbjudande
INSERT jobberbjudande
(ftgnamn,
erbjnamn,
senastansok,
tillsattning,
befattning,
ingangslon)
VALUES('ICA Nara Ljung',
'Butiksbiträde ',
CONVERT(DATETIME, '2010-09-25 00:00:00.000', 121),
CONVERT(DATETIME, '2010-10-15 00:00:00.000', 121),
'Biträde ',
'15000')

INSERT jobberbjudande
(ftgnamn,
erbjnamn,
senastansok,
tillsattning,
befattning,
ingangslon)
VALUES('ICA Nara Ljung',
'Kassamedarbetare ',
CONVERT(DATETIME, '2010-11-01 00:00:00.000', 121),
CONVERT(DATETIME, '2011-01-01 00:00:00.000', 121),
'Kassörska ',
'12000')

INSERT jobberbjudande
(ftgnamn,
erbjnamn,
senastansok,
tillsattning,
befattning,
ingangslon)
VALUES('Manpower ',
'Projektledare ',
CONVERT(DATETIME, '2010-11-12 00:00:00.000', 121),
CONVERT(DATETIME, '2011-02-01 00:00:00.000', 121),
'Projektledare ',
'32000')

INSERT jobberbjudande
(ftgnamn,
erbjnamn,
senastansok,
tillsattning,
befattning,
ingangslon)
VALUES('Manpower',
'Systemutvecklare',
CONVERT(DATETIME, '2010-10-01 00:00:00.000', 121),
CONVERT(DATETIME, '2011-01-01 00:00:00.000', 121),
'Programmerare',
'20000')

INSERT jobberbjudande
(ftgnamn,
erbjnamn,
senastansok,
tillsattning,
befattning,
ingangslon)
VALUES('Manpower',
'Webbutvecklare',
CONVERT(DATETIME, '2010-12-13 00:00:00.000', 121),
CONVERT(DATETIME, '2011-03-01 00:00:00.000', 121),
'Programmerare',
'22000')

INSERT jobberbjudande
(ftgnamn,
erbjnamn,
senastansok,
tillsattning,
befattning,
ingangslon)
VALUES('Pulsen',
'Ekonom',
CONVERT(DATETIME, '2010-10-19 00:00:00.000', 121),
CONVERT(DATETIME, '2010-12-13 00:00:00.000', 121),
'Redovisningsansvarig',
'23000')

INSERT jobberbjudande
(ftgnamn,
erbjnamn,
senastansok,
tillsattning,
befattning,
ingangslon)
VALUES('Pulsen',
'IT-arkitekt',
CONVERT(DATETIME, '2010-11-15 00:00:00.000', 121),
CONVERT(DATETIME, '2011-02-01 00:00:00.000', 121),
'Systemarkitekt',
'25000')

INSERT jobberbjudande
(ftgnamn,
erbjnamn,
senastansok,
tillsattning,
befattning,
ingangslon)
VALUES('Pulsen',
'Projektledare',
CONVERT(DATETIME, '2010-10-05 00:00:00.000', 121),
CONVERT(DATETIME, '2010-12-24 00:00:00.000', 121),
'Projektledare',
'30000')

INSERT jobberbjudande
(ftgnamn,
erbjnamn,
senastansok,a
tillsattning,
befattning,
ingangslon)
VALUES('TA',
'Ekonom',
CONVERT(DATETIME, '2010-11-04 00:00:00.000', 121),
CONVERT(DATETIME, '2011-01-01 00:00:00.000', 121),
'Ekonom',
'19000')

INSERT jobberbjudande
(ftgnamn,
erbjnamn,
senastansok,
tillsattning,
befattning,
ingangslon)
VALUES('TA',
'Maskinist',
CONVERT(DATETIME, '2010-09-30 00:00:00.000', 121),
CONVERT(DATETIME, '2010-10-15 00:00:00.000', 121),
'Maskinist',
'12500')

jonas85
Starting Member

3 Posts

Posted - 2010-10-10 : 16:00:17

and the error i received from microsoft sql management

Msg 2627, Level 14, State 1, Line 2
Violation of PRIMARY KEY constraint 'PK__formedlare__7E6CC920'. Cannot insert duplicate key in object 'dbo.formedlare'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 10
Violation of PRIMARY KEY constraint 'PK__formedlare__7E6CC920'. Cannot insert duplicate key in object 'dbo.formedlare'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 18
Violation of PRIMARY KEY constraint 'PK__formedlare__7E6CC920'. Cannot insert duplicate key in object 'dbo.formedlare'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 3
Violation of PRIMARY KEY constraint 'PK__foretag__7C8480AE'. Cannot insert duplicate key in object 'dbo.foretag'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 17
Violation of PRIMARY KEY constraint 'PK__foretag__7C8480AE'. Cannot insert duplicate key in object 'dbo.foretag'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 31
Violation of PRIMARY KEY constraint 'PK__foretag__7C8480AE'. Cannot insert duplicate key in object 'dbo.foretag'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 45
Violation of PRIMARY KEY constraint 'PK__foretag__7C8480AE'. Cannot insert duplicate key in object 'dbo.foretag'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 3
Violation of PRIMARY KEY constraint 'PK__sokande__0425A276'. Cannot insert duplicate key in object 'dbo.sokande'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 17
Violation of PRIMARY KEY constraint 'PK__sokande__0425A276'. Cannot insert duplicate key in object 'dbo.sokande'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 31
Violation of PRIMARY KEY constraint 'PK__sokande__0425A276'. Cannot insert duplicate key in object 'dbo.sokande'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 45
Violation of PRIMARY KEY constraint 'PK__sokande__0425A276'. Cannot insert duplicate key in object 'dbo.sokande'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 3
Violation of PRIMARY KEY constraint 'PK__ansokan__023D5A04'. Cannot insert duplicate key in object 'dbo.ansokan'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 17
Violation of PRIMARY KEY constraint 'PK__ansokan__023D5A04'. Cannot insert duplicate key in object 'dbo.ansokan'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 31
Violation of PRIMARY KEY constraint 'PK__ansokan__023D5A04'. Cannot insert duplicate key in object 'dbo.ansokan'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 45
Violation of PRIMARY KEY constraint 'PK__ansokan__023D5A04'. Cannot insert duplicate key in object 'dbo.ansokan'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 59
Violation of PRIMARY KEY constraint 'PK__ansokan__023D5A04'. Cannot insert duplicate key in object 'dbo.ansokan'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 73
Violation of PRIMARY KEY constraint 'PK__ansokan__023D5A04'. Cannot insert duplicate key in object 'dbo.ansokan'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 87
Violation of PRIMARY KEY constraint 'PK__ansokan__023D5A04'. Cannot insert duplicate key in object 'dbo.ansokan'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 101
Violation of PRIMARY KEY constraint 'PK__ansokan__023D5A04'. Cannot insert duplicate key in object 'dbo.ansokan'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 115
Violation of PRIMARY KEY constraint 'PK__ansokan__023D5A04'. Cannot insert duplicate key in object 'dbo.ansokan'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 129
Violation of PRIMARY KEY constraint 'PK__ansokan__023D5A04'. Cannot insert duplicate key in object 'dbo.ansokan'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 143
Violation of PRIMARY KEY constraint 'PK__ansokan__023D5A04'. Cannot insert duplicate key in object 'dbo.ansokan'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 157
Violation of PRIMARY KEY constraint 'PK__ansokan__023D5A04'. Cannot insert duplicate key in object 'dbo.ansokan'.
The statement has been terminated.
Msg 102, Level 15, State 1, Line 119
Incorrect syntax near 'tillsattning'.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources