Thanks for the article, it explains the APPLY in a simple and straightforward manner.

As a newby, could you explain to me why and when you would use :

SELECT * FROM...