I would like to have a view that I could run return multiple result sets. Is this possible?
If a view can not do this, then is there another object with High Visibility/Transparency within SQL Server that can achieve this? (I like using a view because I can easily see it and run it under the Views folder). A stored procedure is not really ideal because I have so many.
Thanks