A new feature in Power Apps is SQL Stored Procedures that can be called directly ... No looping through data, just copying the data structure and type casting it on the way is a lot faster.

This screenshot lists the source of a SQL Server 2014 stored procedure hitting the AdventureWorks2012 ... Stephen Glasskeys To execute, pass in an XML structure similar to one found in the ...

You can use full, inline SQL statements in the prepared statement function or send the database a stored procedure function. A stored procedure is a program that is stored on the database server.

How do I go about creating a dataset for this report that uses a stored procedure/sql view which will pull out a dynamic list of tables to query from? My goal is to be able to select "Server1 ...