Ars Technica

concurrent sql commands in T-SQL under SQL Server in a stored proc?

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