Umbraco Member information in one Row

Posted 20 July 2017 by Darren Welch

The membership model allows you to create custom fields for your members, this means that each piece of information will be stored in it's own row, allowing you to add as much information as you like.

So for our example, our members contain custom data of:


  • Salutation
  • First Name
  • Last Name
  • Telephone
  • Address


This is stored in the CMSPropertyData and the CMSPropertyType tables.

So down to business....


You need to use SQLs Pivot method.


,address FROM ( SELECT
,CAST(COALESCE(pd.dataNVarchar,pd.datantext) AS VARCHAR(1000)) AS [value]
,pt.Name as [columnname] FROM cmsMember m JOIN cmsPropertyData pd ON m.nodeId = pd.contentNodeId JOIN cmsPropertyType pt ON = pd.propertytypeid ) d pivot ( MAX(value) FOR columnname in (salutation,firstname,lastname,telephone,address ) piv


It's as simple as that. Just replace the columns with the name of your columns.

Darren Welch


Darren Welch

  20 July 2017

Contact me online



SQL Server sql tsql pivot code

Has this helped?

If this has saved you time and you are feeling generous, why not buy me a coffee.

Thank You cup of coffee

Related Content