Topological sort of object dependencies.sql

/*
    Everything with no dependencies comes first. That way, when a new item is added with a dependency on an existing item, it doesn't cause the existing item to jump.
    Of course an existing item taking a dependency on an existing item will cause a jump, may as well move the changing item.
    An existing item taking a dependency on a new item will also jump. It doesn't really make sense to putting the new item first, out of order, if it doesn't have dependencies.

    Basically: order by depth_of_deepest_dependency, original_order
*/

with
    creating_objects as (
        select
            object_id,
            row_number() over (order by schemas.name, objects.name) as original_order
        from sys.objects
        join sys.schemas on schemas.schema_id = objects.schema_id
        where objects.type in ('v', 'p', 'if', 'tf') and schemas.name = 'vw'
    ),
    creating_dependencies as (
        select
            referencing_id,
            referenced_id
        from sys.sql_expression_dependencies
        join creating_objects on creating_objects.object_id = referenced_id
        where referencing_id != referenced_id
    ),
    recursive_depth_calculator as (
        select
            object_id,
            0 as depth
        from creating_objects
        left join creating_dependencies on referencing_id = object_id
        where referencing_id is null

        union all

        select
            current_depth.referencing_id,
            depth + 1
        from recursive_depth_calculator
        join creating_dependencies current_depth on object_id = referenced_id
    )
select ids_with_depth.object_id from (
    select
        object_id,
        max(depth) as max_depth
    from recursive_depth_calculator
    group by object_id
) ids_with_depth
join creating_objects on creating_objects.object_id = ids_with_depth.object_id
order by max_depth, original_order

@UbhiTS I'm glad it helped! :')