USP_DATALIST_EVENTCALENDARSITE

CREATE procedure dbo.USP_DATALIST_EVENTCALENDARSITE
as
    set nocount on;

    select 
        SITE.ID as SITEID, 
        (select 
            PARENTSITE.ID 
        from 
            dbo.SITE AS PARENTSITE 
        where 
            SITE.HIERARCHYPATH.GetAncestor(1) = PARENTSITE.HIERARCHYPATH
        ) as PARENTSITEID
    from 
        dbo.SITE