Find out the next business days using Outer Apply Clause

Suppose we have something as under -

DATE	LEAVEDAYS	NXTWRKDAYS
2014-07-01	No	NULL
2014-07-02	No	NULL
2014-07-03	No	NULL
2014-07-04	No	NULL
2014-07-05	Yes	NULL
2014-07-06	Yes	NULL
2014-07-07	Yes	NULL
2014-07-08	No	NULL

We need to find out the next business days such that the output will look as

DATE	LEAVEDAYS	NXTWRKDAYS
2014-07-01	No	2014-07-02
2014-07-02	No	2014-07-03
2014-07-03	No	2014-07-04
2014-07-04	No	2014-07-05
2014-07-05	Yes	2014-07-08
2014-07-06	Yes	2014-07-08
2014-07-07	Yes	2014-07-08
2014-07-08	No	2014-07-09 

The below outer-apply query will help to do so

declare @t table([DATE] DATE,LEAVEDAYS Varchar(10),NXTWRKDAYS DATE)

insert into @t Values

('2014-07-01','No',NULL),

('2014-07-02','No',NULL),

('2014-07-03','No',NULL),

('2014-07-04','No',NULL),

('2014-07-05','Yes',NULL),

('2014-07-06','Yes',NULL),

('2014-07-07','Yes',NULL),

('2014-07-08','No',NULL)

SELECT
    t.[DATE],
    t.LEAVEDAYS,
    NXTWRKDAYS = x.[DATE]
FROM @t t
OUTER APPLY(
    SELECT TOP 1 [DATE]
    FROM @t
    WHERE 
        [DATE] > t.[DATE]
        AND LEAVEDAYS = CASE WHEN t.LEAVEDAYS = 'YES' THEN 'NO' ELSE LEAVEDAYS END          
) x