Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
--------get rdl for each report------------ SELECT ds.[name] as datasource , c.[name] as report , CAST(CAST(content AS VARBINARY(max)) AS XML) as rdl , LEFT( c.path, LEN(c.path) - LEN(c.[name]) ) as folder INTO #tmp FROM dbo.Catalog c INNER JOIN dbo.DataSource ds ON c.ItemId = ds.ItemId WHERE ds.[name] IS NOT NULL ORDER BY datasource, report -------------get stored procedure name---------- SELECT rdl , rdl.value( '(/Report/DataSets/DataSet/Query/CommandType)', 'VARCHAR(50)') , rdl.value( '(/Report/DataSets/DataSet/Query/CommandText)', 'VARCHAR(50)') FROM #tmp
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!