SELECT DISTINCT 
  SUBSTRING(vdp.ServerNALPath, CHARINDEX('\\', vdp.ServerNALPath) + 2, CHARINDEX('"]', vdp.ServerNALPath) - CHARINDEX('\\', vdp.ServerNALPath) - 3 ) AS C070,
  vdp.SiteCode,
  case when vdp.IsPeerDP=1 then '*' else '' end as BranchDP,
  @PkgID AS [Package ID]
FROM
  v_DistributionPoint vdp
WHERE 
  vdp.ServerNALPath NOT IN 
  (
    SELECT DISTINCT 
      vdp.ServerNALPath
    FROM
      v_DistributionPoint vdp
    WHERE
      vdp.PackageID = @PkgID
  ) 
OR
  vdp.ServerNALPath IN 
  (
    SELECT 
      ServerNALPath
    FROM
      v_PackageStatusDistPointsSumm vpsdps
    WHERE
      vpsdps.InstallStatus <> 'Package Installation complete'
    AND
      vpsdps.PackageID = @PkgID
  )
ORDER BY C070