I am looking for a simple example of how to pass the [TempVars] variables from an MS Access VBA to a MS SQL 2008 stored procedure.
Currently within a MS Access query I am performing an extremely long and complicated expression to retrieve a field value. The expression is referencing various SQL views and tables linked within the Access db. This seems inefficient and depending on the user's privileges and timeout parameters, can sometimes error out.
I want to be able to have SQL do the heavy lifting, and just passback the expected query results.
I am using MS Access to produce the output because the SQL application does not have a reporting module I can use.
So to summarize my question, is there a link on setting something like this up?