;With CTE
AS
(
SELECT shop_code,
product_Id,
doc_date,
t2.outputer,
t3.doc_date AS NextDate
FROM itog00 t1
OUTER APPLY (
SELECT TOP 1 outputer
FROM itog00
WHERE shop_code = t1.shop_code
AND product_id = t1.product_id
AND doc_date > t1.doc_date
AND mark_1 = 1
AND HolidayWeek= 0
ORDER BY doc_date)t2
OUTER APPLY
(
SELECT doc_date
FROM itog00
WHERE shop_code = t1.shop_code
AND product_id = t1.product_id
AND doc_date > t1.doc_date
AND mark_1 = 1
AND HolidayWeek= 1
ORDER BY doc_date)t3
WHERE mark_1 = 1
AND HolidayWeek= 1
ORDER BY doc_date
)