Not as sophisticated as the prior posts, but here is what I use to get things into a table format for a given example of a FnL implementation. It has to be customized for each implementation obviously. Maybe it will help you.

SELECT
R.UserDefinedRowId as ID,
CONVERT(VARCHAR(10), max (cast((CASE WHEN F.FieldTitle = 'Start Date' THEN D.FieldValue ELSE '' END) as nvarchar(50))), 105) AS [Start Date],
max (cast((CASE WHEN F.FieldTitle = 'WMS' THEN D.FieldValue ELSE '' END) as nvarchar(50))) AS WMS,
max (''+ cast((CASE WHEN F.FieldTitle = 'Job Post Title' THEN D.FieldValue ELSE '' END) as nvarchar(50)) + '') as [Job Title],
MAX('$' + CAST((CASE WHEN F.FieldTitle = 'Hourly Rate (Up To)' THEN CONVERT(int, CONVERT(money, CONVERT(nvarchar(10), D .FieldValue))) ELSE '' END)
AS nvarchar(50))) AS [Rate],
max (cast((CASE WHEN F.FieldTitle = 'Need Duration (Months)' THEN D.FieldValue ELSE '' END) as nvarchar(50))) AS [Duration Months],
max (cast((CASE WHEN F.FieldTitle = 'Contact Company' THEN D.FieldValue ELSE '' END) as nvarchar(50))) AS [Contact Company]

FROM dbo.UserDefinedRows AS R LEFT OUTER JOIN
dbo.UserDefinedData AS D ON R.UserDefinedRowId = D.UserDefinedRowId INNER JOIN
dbo.UserDefinedFields AS F ON D.UserDefinedFieldId = F.UserDefinedFieldId
WHERE (F.ModuleId = 1111)
group by

R.UserDefinedRowId

order by [Start Date]

Chad

Old post, but thought I'd share what I created when I went looking for a quick dump of all the FnL data across multiple modules and portals, and found this post.

Using a dynamic query, I was able to pivot the data into columns.  This runs across all of my FnL modules, but could easily be adapted to take a moduleid parameter in that first "SELECT DISTINCT FieldTitle" subquery.

Hope it's helpful,

JR

--Create a dynamic list of distinct field names, putting Created/Changed at the front
declare @fieldlist varchar(max) = 
(
'[Created at],[Created by],[Changed at],[Changed by],'
+
(SELECT SUBSTRING(
(SELECT ',[' + FieldTitle + ']'
FROM (SELECT DISTINCT FieldTitle FROM UserDefinedFields WHERE FieldTitle NOT IN ('Created at','Created by','Changed at','Changed by')) as fieldnames
ORDER BY FieldTitle
FOR XML PATH('')),2,200000)))

--Use the field list to create a dynamic PIVOT query
declare @query varchar(max) =
'SELECT TabPath, ModuleTitle, UserDefinedRowId, ' + @fieldlist +
'from
(
select t.TabPath, tm.ModuleTitle, r.UserDefinedRowId, f.FieldTitle, CAST(d.FieldValue as varchar(MAX)) as FieldValue
FROM dbo.UserDefinedRows AS R LEFT OUTER JOIN
dbo.UserDefinedData AS D ON R.UserDefinedRowId = D.UserDefinedRowId INNER JOIN
dbo.UserDefinedFields AS F ON D.UserDefinedFieldId = F.UserDefinedFieldId
join dbo.TabModules tm on r.ModuleID = tm.ModuleID
join dbo.Tabs t on tm.TabID = t.TabID
) p
PIVOT
(
MAX(FieldValue)
FOR FieldTitle IN (' + @fieldlist + ')
) as pvt'

exec(@query)