#5 Database call from a stored procedure

[Mark Goodwin]

I would like to run a select query from within a
stored procedure.

Given that the stored procedure is being run in the
database engine it would seem that a full database
connection should not be neccessary in order to execute
the statement.

Is there a simply way to get a database connection from
a stored procedure?