004NOR003   2P2   NULL
004NOR003   XYZ  SC

SELECT
	Loc.PlaceRef,
	MAX(CASE 
	     WHEN LocAtt.AttributeCode = 'PAPT' THEN LocAtt.SubAttributeCode
	END) AS [Apt Size],
	MAX(CASE 
	     WHEN LocAtt.AttributeCode = 'SLFC' THEN LocAtt.SubAttributeCode
	END) AS [Contained Status]
FROM
	dbo.vwLocationCurrent AS Loc
	JOIN dbo.vwLocationAttributesCurrent AS LocAtt
		ON  Loc.PlaceRef = LocAtt.PlaceRef
WHERE
	Loc.PlaceRef = '004NOR003'
	AND (
	        LocAtt.AttributeCode = 'PAPT'
	        OR LocAtt.AttributeCode = 'SLFC'
	)
GROUP BY
	Loc.PlaceRef

quote:

---

Originally posted by nokiauk

For each PlaceRef there would be an Apt Size and a Contained Status, the nulls appear as there is no Contanied Status value for Apt Size and vice versa.

The values for Apt Size and Contained Status vary depending on the PlaceRef.

In this case I would like the output to be simply on 1 row:

PlaceRef Apt Size Contained Status
004NOR003 2P2 SC

---