Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Friday, September 27, 2013 8:29 AM


Group: General Forum Members
Last Login: Friday, March 13, 2015 2:34 PM
Points: 100, Visits: 243
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


EXEC sp_1_DumpTestData

EXEC sp_2_InsertOwnersFromOnboard

EXEC sp_3_CleanUpOwnerNames

EXEC sp_4_InsertSalesPersons


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)


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



Group: General Forum Members
Last Login: Tuesday, December 6, 2016 8:08 PM
Points: 16,145, Visits: 16,850
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 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