Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Executing a batch statement within a select

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-12 : 11:20:30
Scott writes "Is is possible to execute a batch statement within a select statement to get a return value for a column.

example (but wrong)
SELECT MemberID, exec sps_getdso AS dso FROM Members.

the column dso would hold the retuned valued from the proc sps_getdso.

SQL 7.0 On Win NT ServicePack 6"

   

- Advertisement -