Executing stored procedure in select query

Question

I'm using SQL Server 2008 R2 and how can I execute a select query with a execute stored procedure?

Jignesh Trivedi · Answer

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.

Pradeep Shet · Answer

Hi There are different ways like EXEC spName sp_executeSql spName Hope this answers your query. Mark it as answered if it is so

Dipankar Biswas · Answer

http://stackoverflow.com/questions/15575260/executing-stored-procedure-in-select-query