Hello,

How are you today?

I need to pass parameters from an Access front end form to a Stored Procedure. I found a method of doing this:

http://p2p.wrox.com/post.asp?method=Topic&FORUM_ID=5

My challenge is that the stored procedure is not called directly, instead I use this query:

SELECT regionorder, Regions3, 1 As Quarter, January as A, February as B, March as C FROM RegionofResidenceCrosstab
UNION ALL
SELECT regionorder, Regions3, 2 As Quarter, April, May, June FROM RegionofResidenceCrosstab
UNION ALL
SELECT regionorder, Regions3, 3 As Quarter, July, August, September FROM RegionofResidenceCrosstab
UNION ALL SELECT regionorder, Regions3, 4 As Quarter, October, November, December FROM RegionofResidenceCrosstab;

and the Union query then calls the crosstab query which needs the parameters that are passed. Can a stored procedure call another stored procedure and pass parameters to it, and if so, how can this be done?

A stored procedure can call another stored procedure, such as:

set @rs = exec newsp @param1, @param2, ... etc

The exec method executes stored procedures within the stored procedures.

Hello,

Thanks for the response.

Not sure how/if I can exec and pass parameters using Union. Remember RegionofResidenceCrosstab is my stored procedure.

Or to ask a different way, can I select from the results of a stored procedure?

You may be able to select the results of the SP, or do:

set @rs = exec new sp ...

select ..., @rs... etc.