WITH CTE AS (

SELECT DISTINCT Store, PhoneNr,

ROW_NUMBER() OVER(PARTITION BY Store ORDER BY PhoneNr) AS Items

FROM ##testEnvironment)

SELECT Store,(SELECT PhoneNr FROM CTE AS C WHERE...