SELECT *
FROM
(
SELECT  ROW_NUMBER() OVER (PARTITION BY CTZ.[Territory_Zip_ID] ORDER BY CTZ.[Territory_Zip_ID]) AS Seq,
,CTZ.[Territory_Zip_ID]
,CTZ.[Zip_Code]
,CTZ.[Zip_Code_Extension_From]
,CTZ.[Zip_Code_Extension_To]
,ZC.City_Town
,SP.State_Name AS State_Province
,CO.Country_Name AS Country
FROM TERRITORY_ZIPCODE CTZ
Inner Join ZIP ZC On (CTZ.Zip_Code = ZC.Zip_Code)
Inner Join STATE SP on (SP.State_Code = ZC.State_Province)
Inner Join COUNTRY CO on (CO.Country_ID = SP.Country_ID)
WHERE District_Territory_Id = @pTerritory_Id
)t
WHERE Seq=1

quote:

---

Originally posted by Jeff Moden

I'm betting that ZipCode isn't unique.

--Jeff Moden

---

RBAR is pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row".

First step towards the paradigm shift of writing Set Based code:
"Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

When writing schedules, keep the following in mind:
"If you want it real bad, that's the way you'll likely get it."

---