SELECT u.UserId, UserName, DisplayName,
(SELECT u2.Value FROM [User Profile] u2 WHERE u2.Property="Age" AND u2.UserId = u.UserId) AS Age,
(SELECT u3.Value FROM [User Profile] u3 WHERE u3.Property="Address" AND u3.UserId = u.UserId) AS Address,
(SELECT u4.Value FROM [User Profile] u4 WHERE u4.Property="Email" AND u4.UserId = u.UserId) AS Email
FROM User u