• To execute the second part of the stored procedure you need to include the 2.

    exec SelectTest -- will return the select from the first query

    exec SelectTest;2 -- will return the select from the second query