If it isn't paging you are after, then consider NTILE(8) OVER()
NTILE()

There's a rowcount Top operator in your plan with only one reason I can think of: SET ROWCOUNT issued before the query.
When I issue SET ROWCOUNT 1 before...

-- If VisitID is a string within PcsAssmntDataID bounded by spaces,
-- then you could use a string-splitter followed by LEN or something
-- else to collect the...

It's easy enough to model your query. This is sufficient:
SELECT c1.City, c1.Postcode
FROM Customer c1
WHERE NOT EXISTS (
 SELECT FanID 
 FROM Customer c2
 WHERE c2.Lastname =...

Using your original table definition I created a temp table with 7047 rows and set to work.