this is caused by your joins, you get one record per property. You might use a left join with an appropriate subquery instead.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

here is a sample from another site:

SELECT U.UserID, U.DisplayName, U.FirstName, U.LastName, U.Username, U.Email, P0.Company, P1.Country
FROM dbo.Users AS U
 LEFT OUTER JOIN (SELECT UP.UserID, UP.PropertyValue AS Company FROM dbo.UserProfile AS UP
                                     INNER JOIN dbo.ProfilePropertyDefinition AS PD ON UP.PropertyDefinitionID = PD.PropertyDefinitionID
                                     WHERE (PD.PropertyName LIKE 'Company')) AS P0 ON U.UserID = P0.UserID
 LEFT OUTER JOIN (SELECT UP.UserID, UP.PropertyValue AS Country FROM dbo.UserProfile AS UP
                                     INNER JOIN dbo.ProfilePropertyDefinition AS PD ON UP.PropertyDefinitionID = PD.PropertyDefinitionID
                                     WHERE (PD.PropertyName LIKE 'Country')) AS P1 ON U.UserID = P1.UserID 
WHERE U.UserID IN
(SELECT User FROM dbo.UserRoles WHERE (RoleID = 5)) /*select members of a specific role */

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN