What is the best way to filter or otherwise manipulate the results returned by a stored procedure?
One possible solution is to put the result set into a temp table and select from it. Here is an example for sp_who2: SQL Server: Filter output of sp_who2