Executing a SP within a SP with Params. Syntax check

  • 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??

  • 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