Parameterise Sql Stored Procedure Excel Get&transform

I'm trying to call a stored select procedure from SQL Server into Excel. In SSMS could be written as @val1=1; @val2=2; Execute SP_DoStuff(@param1=@val1,@param2=@val2); Looking at

Solution 1:

You can use Value.NativeQuery to write parameterized queries. For example, if you wanted a query that only showed columns with the name Alice, you could do

Value.NativeQuery(Sql.Database("server", "database"), "select Name from Employees where Name = @myName", [ myName = "Alice" ])