• the OPENROWSET within Eli Leibas SP to create a view from the output of another SP:-)

    http://www.sqlservercentral.com/articles/T-SQL/68233/

    this is cool and i use it often