Hi all!

This did the trick:

Delete from dbo.dutyrostershift

From

dbo.dutyrostershift A

inner Join dbo.vacation B ON A.dato BETWEEN CONVERT(datetime,B.start-36163,105) AND Convert(datetime,B.fld_end-36163,105) AND B.personalid = A.employeeid

Join DBO.PERSONAL C ON A.employeeid = C.per_personal_id

where B.Wish_Vacation = 1 and A.shifttype = 1 and (C.vacation_as_duty = 0 OR C.vacation_as_duty = 2)

Thanks for the help:-)!

Best regards

Edvard Korsbæk