you have two select statements in one store procedure?
i guess that when you run it, it shows one after another?

if so why are you doing it this way? can you combine them?

store procedure should always return one recordset...