Hi

Have you tried setting the NOCOUNT to ON in the beginning of your SP?

This could prevent extra result sets from interfering with SELECT statements

SET NOCOUNT ON