I made a query (SQL) where I can put the extended properties (right click on table, go to properties, then to extended properties and enter metadata under name/value) of a table in a separate table.
I want SharePoint 2010 to be able to run that query and display the metadata (results) in SharePoint. Do I need a custom web part for that? How is this done? I'm new to SharePoint 2010 and SQL.
p.s. I already know about BDC/BCS, etc. I'm wondering how SharePoint can actually run the query and show me the results (final table).
In other words, how can I have SharePoint run a SQL Query and give me the data I want? Thanks!
For clarification, I can do all this stuff manually on SQL Server, but I want SharePoint to do it.