I think the key information in the article is that you can use OPENROWSET to turn the output of a stored proc to a recordset.

This message got a bit lost with all the stuff relating to creating a view with dynamic sql.

The article could have been structured differently, to deliver the message first strongly and clearly i.e HOW TO DO IT, and WHY THIS IS USEFUL. (A discussion about the difficulties in sorting and filtering the output of a stored procedure.)

Then, as a 'bonus', the stuff about automating the view creation, could have been tagged on.

But I'm giving you five stars anyway, just for including the code for OPENROWSET.

Thanks,

David.