Please Note that I have changed address
Go to
Baking Ways / Productive Bytes

Search This Blog


Wednesday, October 5, 2011

How to call a parametric stored procedure from Microsoft Excel Query

This is a very nice trick to call a stored procedure with parameters from excel.

If you type for example

exec model.GetPrices (?,?,?,?)


CALL model.GetPrices (?,?,?,?)

you will get this message

"Parameters are not allowed in queries that can't be displayed graphically"

while instead if you put the second Call within {} like that

{CALL model.GetPrices (?,?,?,?)}

it will work!!!