Home Forums SQL Server 2012 SQL Server 2012 - T-SQL IF or WHILE statements with Stored Procedures RE: IF or WHILE statements with Stored Procedures

  • February 5, 2016 at 9:48 am

    #1856923

    OK I have run this:

    DECLARE @ResultSet INT

    EXEC @Resultset =spMyStoredProc

    SELECT @ResultSet

    I get two results

    First result:

    EXEC @Resultset =spMyStoredProc returns

    387961

    387962

    Second result:

    SELECT @ResultSet returns

    0