Yes a sproc can return multiple resultsets and you can even work with them in ADO, though it is somewhat esoteric.

SQL Server 2025 delivers major performance upgrades alongside licensing changes that can reshape both operational speed and budget strategy. Smarter query execution, refined CPU scheduling, and better ...