September 27, 2013 at 8:29 am
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.
[font="Courier New"]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
[/font]
SPs #2 and #4 are expecting these two values as well. How can I pass these params to those SPs as well.
Something like...
[font="Courier New"]EXEC sp_2_InsertOwnersFromOnboard(@StartPoint, @EndPoint)[/font]
Right??
September 27, 2013 at 8:43 am
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply