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'