I can't execute the "second one". I have two different SELECT-Statement but it always executes the first one (in Query Analyzer).
BTW: The code looks frightening
jan
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
From BOL
";number
Is an optional integer used to group procedures of the same name so they can be dropped together with a single DROP PROCEDURE statement. For example, the procedures used with an application called orders may be named orderproc;1, orderproc;2, and so on. The statement DROP PROCEDURE orderproc drops the entire group. If the name contains delimited identifiers, the number should not be included as part of the identifier; use the appropriate delimiter around procedure_name only."
-Kevin
