WITH BUDesc (

    ServerID

    ,Description

    )

AS (

    SELECT dbo.BU.BUDesc AS Description

        ,cc.ServerID

    FROM dbo.Server_CostCenter cc

    INNER JOIN dbo.CostCenterMaster ccm ON cc.CostCenterMasterID = ccm.CostCenterMasterID

    INNER JOIN dbo.BU ON ccm.BUID = dbo.BU.BUID

    UNION ALL

    SELECT dbo.OwningDivisionUK.OwningDivisionUKDescription + ' ' + dbo.OwningSubDivisionUK.OwningSubDivisionUKDescription AS Description

        ,cc.ServerID

    FROM dbo.OwningDivisionUK div

    INNER JOIN dbo.CostCenterMasterUK ccm ON div.OwningDivisionUKID = ccm.OwningDivisionUKID

    INNER JOIN dbo.OwningSubDivisionUK subdiv ON ccm.OwningSubDivisionUKID = subdiv.OwningSubDivisionUKID

    INNER JOIN dbo.CostCenterMapUK ccmap ON div.OwningDivisionUKID = ccmap.OwningDivisionID

        AND subdiv.OwningSubDivisionUKID = ccmap.SubDivisionID

    RIGHT OUTER JOIN dbo.Server_CostCenterUK cc ON ccm.CostCenterMasterUKID = ccCostCenterMasterUKID

    )

SELECT *

FROM BUDesc

​