Msg 2627 Violation of PRIMARY KEY constraint
tblShowteam has primary key on teams column  (


  create table tblShowteam(
  SetId           int,
  datum           date,
  teams           int,
  primary key (teams));


You are inserting rows with the same primary key (1) multiple time :

insert into tblShowteam values (1, '2014-06-28', 1);  
--the same as  "insert into tblShowteam (SetId,datum,teams) VALUES (...,1);
insert into tblShowteam values (2, '2014-06-05', 1) ; --it's gonna fail , record with 
-- teams = 1 already exists


I guess setId was supposed to be primary key, not teams.