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)
 Using stored procedures within a select statement

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-24 : 09:16:45
Nick writes "Hey, I hope you can help. I'm using SQL Server 7 sp3 on Windows NT 4.0 sp6.

I was wondering if it's possible to use a stored procedure within a select statement.

Something like this ...
Select (usp_GetContractID AccountID), Account.*
From Account

This would return all the records from the Account table and also return a ContractID for each AccountID in the table.

Is this sort of thing possible?

Thanks in advance."
   

- Advertisement -