Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Executing a SP within a SP with Params. Syntax check Expand / Collapse
Author
Message
Posted Friday, September 27, 2013 8:29 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:54 PM
Points: 82, Visits: 204
Hey guys -

I'm building a SP that essentially fires of a series of other SPs which load data into tables. Since it's early in the development and I test over and over and over, I'd like to limit (duh) the test results to QTYs I determine at the time instead of hundreds of thousands of records with each test. So...I've been manually updating all the SELECT/ INSERT statements to only include records X to Y.

I'm trying to have this master SP prompt me for the range of records to test and then pass those same two values to other SPs needing them. Should be very easy but I'm tripping over syntax.


Here's my "master" SP.


ALTER PROCEDURE [dbo].[sp_00_BigRedButton]

@StartPoint int,
@EndPoint int

AS
BEGIN

EXEC sp_1_DumpTestData

EXEC sp_2_InsertOwnersFromOnboard

EXEC sp_3_CleanUpOwnerNames

EXEC sp_4_InsertSalesPersons

END


SPs #2 and #4 are expecting these two values as well. How can I pass these params to those SPs as well.

Something like...

EXEC sp_2_InsertOwnersFromOnboard(@StartPoint, @EndPoint)

Right??



Post #1499423
Posted Friday, September 27, 2013 8:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:05 PM
Points: 11,927, Visits: 10,967
You would call those other procs just like any other (parenthesis are not used in a proc call).

EXEC sp_2_InsertOwnersFromOnboard @StartPoint, @EndPoint



_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1499434
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse