Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Three linked stored procedures

Status
Not open for further replies.
Gjj

Gjj

Programmer
Sep 23, 2005
15
YU
I have one stored procedure SP1 whose parameter sp1_a1 is linked to sub report procedure SP2_a1. Due to some changes I would like to add to report one more procedure which have all parameters as SP1 and than that procedure will be linked with SP2.
Also I would like to enter only parameters for SP1 and then to use that same values for new procedure which will be linked to SP2.
Can I do that?
 
Sort by date Sort by votes
Hi
Have you try a storeprocedure that contains all your query into one procedure?



Durango122
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Question
Stored Procedure with no Parameters
Replies
1
Views
263
hilfy
hilfy
0sprey
  • Locked
  • Question
Comparing three (3) Tables in a MS Access database with CR11 Report
Replies
1
Views
58
Charliy
Charliy
allyne
  • Locked
  • Question
RE: SAP Crystal Reports 2008 Multi Parameter in Stored Procedure
Replies
1
Views
64
briangriffin
briangriffin
kate8
  • Locked
  • Question
NULL value parameter passed from Crystal Report into Stored Procedure
Replies
8
Views
197
kate8
kate8
wiplash
  • Locked
  • Question
stored procedure prompt
Replies
3
Views
62
wiplash
wiplash

Part and Inventory Search

Sponsor

Back
Top