[font="Verdana"]SWEEEEEET --- thank you!!!![/font] 😛

Thanks, yes I mean adajacent days. Here a table script:

CREATE TABLE dbo.EmployeeStatus

(

MID intnot null

Datum datenot null

ID_Status intnot null

);

GO

INSERT INTO dbo.EmployeeStatus(MID, Datum, ID_Status) VALUES(7, '2012-01-02',1);

INSERT INTO...