Office Canvas Version 1 will include a new capability for generating SQL statements that can be used for advanced reporting on SharePoint data. These statements include SELECT, SELECTINTO, and CREATEVIEW. Using the function fn_ncf_BuildListSql will return a SQL statement can be executed against a SharePoint Content Database to return list data. The following are usage examples:
SELECT INTO
declare @s varchar(max)
exec @s = fn_ncf_BuildListSql 'SELECTINTO', '', 'Canvas Tasks', '##MyTempTable', ''
exec(@s)
SELECT
declare @s varchar(max)
exec @s = fn_ncf_BuildListSql 'SELECT', '', 'Canvas Tasks', '', ''
exec(@s)
CREATE VIEW
declare @s varchar(max)
exec @s = fn_ncf_BuildListSql 'CREATEVIEW', '', 'Canvas Tasks', '', 'CanvasTasks'
exec(@s)