This should be simple, but I'm a bit confused by these two.<br><br>As I understand it your stored procedure can have 3 values/paramater types:<br>Input paramters (which are obviously what you pass in, ...
Anyone have any idea how I can convert this to a Access query: (Mainly how do I declare variable and a table???)<br><br><br>CREATE PROCEDURE GetProductsInCategory<br>(@CategoryID ...
Note: The SQL procedure displays the variable labels as stored in the view. However, because you are referencing a view descriptor, you must use the SAS variable names in the WHERE clause, not the ...
Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback