Calling a Stored Procedure inside a SELECT

[SoftwareEng]

Hi guys, something doesn't add up.

I wrote a stored proc in SQL Server 2000, called "SP_MultiplyByTen", which simply takes a number as its parameter, and returns that number multiplied by 10.

Now, I want to call it in a SELECT statement, like this:

SELECT Account, Price, SP_MultiplyByTen(Price) FROM Accounts


But I can't! How can I call a stored proc directly in a SELECT and pass it a value from the "current" row? It's driving me nutzzz

thanks

 

[JACKDRUID]

create a function rather than a stored procedure.

 

[KLin]

I Agree with JACKDRUID. A userdefined function is what you need.

http://www.sqlteam.com/article/user-defined-functions

 

[SoftwareEng]

thank you guys, I will check out the user-defined functions.