Using stored procedure in select statement : SQL Server

This video shows how to use SQL Server stored procedure in select statement using "openrowset" function of SQL server.

One can ask what is the use of stored procedure in select statement, so answer is to make join with other queries we can use in select statement.