CREATE TABLE PuvodniDochazka
(
 RC varchar(12) NOT NULL,
 Den date,
 Smena varchar(18),
 Operace varchar(3)
);

INSERT INTO PuvodniDochazka VALUES ('100',CONVERT(date,'1.9.2012',104),'Ranni','01');
INSERT INTO PuvodniDochazka VALUES ('100',CONVERT(date,'1.9.2012',104),'Ranni','02');
INSERT INTO PuvodniDochazka VALUES ('100',CONVERT(date,'1.9.2012',104),'Ranni','05');
INSERT INTO PuvodniDochazka VALUES ('200',CONVERT(date,'2.9.2012',104),'Ranni','01');
INSERT INTO PuvodniDochazka VALUES ('200',CONVERT(date,'2.9.2012',104),'Ranni','05');

CREATE TABLE PlanovanaSmena
(
  Den date,
  Smena varchar(18),
  Kalendar varchar(18)
);

INSERT INTO PlanovanaSmena VALUES (CONVERT(date,'5.9.2012',104),'Ranni','R8');
INSERT INTO PlanovanaSmena VALUES (CONVERT(date,'2.9.2012',104),'Ranni','R8');


SELECT d.RC
       ,d.Smena
       ,d.Den
FROM PuvodniDochazka d
WHERE NOT EXISTS 
 ( SELECT s.Den FROM PlanovanaSmena s
   WHERE d.Den = s.Den AND d.Smena = s.Smena
 );  -- return 3 rows

DELETE FROM PuvodniDochazka 
WHERE NOT EXISTS 
 ( SELECT s.Den FROM PlanovanaSmena s
   WHERE Den = s.Den AND Smena = s.Smena
 ); -- 0 rows affected. Why?
 
update PuvodniDochazka
SET Smena = 'vymaz'
WHERE NOT EXISTS 
 ( SELECT s.Den FROM PlanovanaSmena s
   WHERE Den = s.Den AND Smena = s.Smena
 ); -- 0 rows affected. Why?

DELETE D FROM PuvodniDochazka D
WHERE NOT EXISTS 
 ( SELECT s.Den FROM PlanovanaSmena s
   WHERE D.Den = s.Den AND D.Smena = s.Smena
 );
 
UPDATE D
SET Smena = 'vymaz'
FROM PuvodniDochazka D
WHERE NOT EXISTS 
 ( SELECT s.Den FROM PlanovanaSmena s
   WHERE D.Den = s.Den AND D.Smena = s.Smena
 );