SELECT		MAX(CASE WHEN propertyName = 'FirstName' THEN propertyValue END) AS FirstName,
		MAX(CASE WHEN propertyName = 'LastName' THEN propertyValue END) AS LastName,
		MAX(CASE WHEN propertyName = 'CompanyName' THEN propertyValue END) AS CompanyName,
		userid
FROM		(
			SELECT		PropertyName,
					PropertyValue,
					UserID
			FROM		ProfilePropertyDefinition AS ppd
			INNER JOIN	UserProfile AS up ON up.PropertyDefinitionID = ppd.PropertyDefinitionID
		) AS d
GROUP BY	userid
ORDER BY	userid