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]
SPs #2 and #4 are expecting these two values as well. How can I pass these params to those SPs as well.
EXEC sp_2_InsertOwnersFromOnboard(@StartPoint, @EndPoint)