Holiday Datum   (No column name)
0   2016-02-05  2016-02-05

Holiday Datum   (No column name)
0   2016-02-05  2016-02-08

DECLARE @start DATE
SET @start = '2016-02-01'

DECLARE @end DATE
SET @end = '2016-02-10'

WHILE(@start<=@end)
BEGIN

DECLARE  @Holiday TABLE (Datum DATE,Holiday bit)
INSERT INTO @Holiday

SELECT
CONVERT(NVARCHAR(10),@start,120),
(SELECT CASE
WHEN DATENAME(WEEKDAY,@start) IN ('Saturday','Sunday')
THEN 1
ELSE 0
END) AS Holiday
SET @start = DATEADD(d,1,@start)
END

SELECT * FROM @Holiday

SELECT h.Holiday,h.Datum,
(SELECT
 CASE

  WHEN DATEADD(d,1,h.Datum) = DATEADD(d,1,h.Datum) AND h.Holiday = 1
  THEN (SELECT TOP 1 Datum FROM @Holiday WHERE Datum > h.Datum AND Holiday = 0 )

  ELSE h.Datum
  END)

FROM @Holiday h