Executing stored procedure in select query

Hi,

As per the my knowledge you cannot use Store procedure with select query/ statement.
you can use function instead of stored procedure...

hope this will help you.