View Single Post
  #1 (permalink)  
Old March 29th, 2004, 09:26 AM
blinton25 blinton25 is offline
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Pass though parameters to stored procedures

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?
Reply With Quote