IF NOT EXISTS(SELECT * FROM CarResJourneyList WITH (NOLOCK) WHERE PortFrom = 'Y' AND PortTo = 'R')
  INSERT INTO CarResJourneyList (PortFrom, PortNameFrom, PortTo, PortNameTo, NameListRequired) VALUES ('Y','Ystad','R','Rønne', 0)
  
IF NOT EXISTS(SELECT * FROM CarResJourneyList WITH (NOLOCK) WHERE PortFrom = 'Q' AND PortTo = 'R')
  INSERT INTO CarResJourneyList (PortFrom, PortNameFrom, PortTo, PortNameTo, NameListRequired) VALUES ('Q','Køge','R','Rønne', 1)  
  
IF NOT EXISTS(SELECT * FROM CarResJourneyList WITH (NOLOCK) WHERE PortFrom = 'S' AND PortTo = 'R')
  INSERT INTO CarResJourneyList (PortFrom, PortNameFrom, PortTo, PortNameTo, NameListRequired) VALUES ('S','Sassnitz','R','Rønne', 0)  
  
IF NOT EXISTS(SELECT * FROM CarResJourneyList WITH (NOLOCK) WHERE PortFrom = 'Z' AND PortTo = 'R')
  INSERT INTO CarResJourneyList (PortFrom, PortNameFrom, PortTo, PortNameTo, NameListRequired) VALUES ('Z','Stettin','R','Rønne', 0)  

IF NOT EXISTS(SELECT * FROM CarResJourneyList WITH (NOLOCK) WHERE PortFrom = 'B' AND PortTo = 'R')
  INSERT INTO CarResJourneyList (PortFrom, PortNameFrom, PortTo, PortNameTo, NameListRequired) VALUES ('B','Bus 866 - København','R','Rønne', 0)  

IF NOT EXISTS(SELECT * FROM CarResJourneyList WITH (NOLOCK) WHERE PortFrom = 'R' AND PortTo = 'Y')
  INSERT INTO CarResJourneyList (PortFrom, PortNameFrom, PortTo, PortNameTo, NameListRequired) VALUES ('R','Rønne','Y','Ystad', 0)  
  
IF NOT EXISTS(SELECT * FROM CarResJourneyList WITH (NOLOCK) WHERE PortFrom = 'R' AND PortTo = 'Q')
  INSERT INTO CarResJourneyList (PortFrom, PortNameFrom, PortTo, PortNameTo, NameListRequired) VALUES ('R','Rønne','Q','Køge', 1)  

IF NOT EXISTS(SELECT * FROM CarResJourneyList WITH (NOLOCK) WHERE PortFrom = 'R' AND PortTo = 'S')
  INSERT INTO CarResJourneyList (PortFrom, PortNameFrom, PortTo, PortNameTo, NameListRequired) VALUES ('R','Rønne','S','Sassnitz', 0)  

IF NOT EXISTS(SELECT * FROM CarResJourneyList WITH (NOLOCK) WHERE PortFrom = 'R' AND PortTo = 'B')
  INSERT INTO CarResJourneyList (PortFrom, PortNameFrom, PortTo, PortNameTo, NameListRequired) VALUES ('R','Rønne','B','Bus 866 - København', 0)  

IF NOT EXISTS(SELECT * FROM CarResJourneyList WITH (NOLOCK) WHERE PortFrom = 'R' AND PortTo = 'Z')
  INSERT INTO CarResJourneyList (PortFrom, PortNameFrom, PortTo, PortNameTo, NameListRequired) VALUES ('R','Rønne','Z','Stettin', 0)  
