How can I exclude, say, 'b' from a row set produced by
create proc #_ as
select 'a' a union
select 'b' union
I know, "use a function returning a table".
But is there an elegant way of manipulating with row set returned by a stored procedure. Backward compatibility plays its role here.