select state, city, location
from dbo.MyCitiesTable
cross apply 
  (select top 30 percent location
  from dbo.MyLocationsTable
  where MyLocationsTable.CityID = MyCitiesTable.ID
  order by location) as Locations ;

WITH 
    Data AS
    (
        SELECT
            a.*
        FROM Person.Address AS a
    ),
    StateProvince AS
    (
        SELECT DISTINCT
             d.StateProvinceID
        FROM Data AS d
    )
SELECT 
    Selected.AddressID,
    Selected.AddressLine1,
    Selected.AddressLine2,
    Selected.City,
    Selected.StateProvinceID,
    Selected.PostalCode
FROM StateProvince
CROSS APPLY
(
    SELECT TOP (30) PERCENT 
        d2.*
    FROM Data AS d2
    WHERE
        d2.StateProvinceID = StateProvince.StateProvinceID
    ORDER BY
        d2.City
) AS Selected
ORDER BY
    StateProvince.StateProvinceID,
    Selected.City;