SELECT  
	v.PermitNumber,
	max(p.ApprovedDate) AS ApprovedDate,
	max(v.ProcessStatus) AS ProcessStatus,
	max(v.PermitTypeDescription) AS PermitTypeDescription,
	max(v.ServiceAddress) AS ServiceAddress,
	max(v.CityStateZip) AS CityStateZip,
	max(v.EstimatedImprovementValue) AS EstimatedImprovementValue,
	max(v.OtherPartyName) AS OtherPartyName,
	max(v.OtherPartyMailingAddress) AS OtherPartyMailingAddress,
	max(v.OtherPartyCityStateZip) AS OtherPartyCityStateZip,
	max(v.ParcelNumber) AS ParcelNumber,
	max(v.PermitIssueTo) AS PermitIssueTo,
	max(v.PermitDescription) AS PermitDescription,
	max(v.CurrentPrimaryOwner) AS CurrentPrimaryOwner
FROM
	PermitCheckList AS p
	INNER JOIN vwPermit AS v
		ON  p.PermitID = v.PermitID
WHERE
	(p.ApprovedDate BETWEEN @StartDate AND @EndDate)
GROUP BY
	v.PermitNumber
ORDER BY
	v.PermitNumber;

with cte as
(SELECT
	DISTINCT 
	v.PermitNumber,
	p.ApprovedDate,
	v.ProcessStatus,
	v.PermitTypeDescription,
	v.ServiceAddress,
	v.CityStateZip,
	v.EstimatedImprovementValue,
	v.OtherPartyName,
	v.OtherPartyMailingAddress,
	v.OtherPartyCityStateZip,
	v.ParcelNumber,
	v.PermitIssueTo,
	v.PermitDescription,
	v.CurrentPrimaryOwner,
	ROW_NUMBER() OVER(PARTITION BY v.PermitNumber ORDER BY (SELECT NULL)) AS RN
FROM
	PermitCheckList AS p
	INNER JOIN vwPermit AS v
		ON  p.PermitID = v.PermitID
WHERE
	(p.ApprovedDate BETWEEN @StartDate AND @EndDate)
)
SELECT * FROM CTE WHERE RN = 1;
ORDER BY
	PermitNumber;