Hi Mark,
Thank you. 🙂
Cheers,
Julian
SELECTA.Week, A.SALDORCNW
FROMMedewerkerUren A
WHEREEXISTS
(
SELECT*
FROMMedewerkerUren B
WHEREB.Week = A.Week-1
AND SIGN(B.SALDORCNW) <> SIGN(A.SALDORCNW)
and A.JAAR = B.JAAR
and A.PERSNR = B.PERSNR
)
AND A.JAAR = 2015
AND A.PERSNR = '014028'