Hi Guys,
has anybody ever tried to pass the value of a query item to a variable of a stored procedure query ?
Perhaps a small (fictive) example to give you an idea of what I'm trying to achieve: we have a stored procedure which makes soe calculations based on a parameter which asks for a product number. We would like to be able to have the user for instance create a report for a product line, and then the report will show all products for that product line (from a regular query subject), and besides each product the resulting calculations from the stored procedure.
Any help will be appreciated
Regards
Filip