with f  as ( select * from TourML.SpoFiles )
                   , fl as ( select * from f where is_directory = 0 and file_type = N'xml' and name = @name )
                   , fo as ( select * from f where is_directory = 1 and name = @dir and parent_path_locator is null )
                   , x  as ( select path_locator = isnull( fl.path_locator
                                                         , fo.path_locator.GetDescendant( (select max(path_locator) from f where parent_path_locator = fo.path_locator ), null)
                                                         )
                                  , name = @name
                                  , file_stream = cast( @XML as varbinary(max) )
                                  , creation_time = @now
                               from fo left outer join fl on fl.parent_path_locator = fo.path_locator
                           )
                  merge f using x on f.path_locator = x.path_locator
                    when not matched then insert( path_locator, name, file_stream, creation_time ) values( path_locator, name, file_stream, creation_time )
                    when matched and ( f.file_stream <> x.file_stream ) then update set file_stream = x.file_stream, creation_time = x.creation_time
               ;

-- висим (т.е. не запускаемя вовсе)
when matched and ( f.file_stream <> x.file_stream ) then update set file_stream = x.file_stream, creation_time = x.creation_time

-- работаем (т.е. запускаемся)
when matched then update set file_stream = x.file_stream, creation_time = x.creation_time

waiting_task_address	session_id	exec_context_id	wait_duration_ms	wait_type	resource_address	blocking_task_address	blocking_session_id	blocking_exec_context_id	resource_description
0x000000083988E558	164	0	0	PREEMPTIVE_OS_FILEOPS	NULL	NULL	NULL	NULL	NULL

when matched and exists(select f.file_stream except select x.file_stream) then update set file_stream = x.file_stream, creation_time = x.creation_time