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  Transact-SQL (2000)  SELECT Fld1, Fld2, MyStoredProc(Fld1, Fld2) AS ...

Author  Topic  samir200 Starting Member 1 Post Posted - 2001-10-04 : 09:23:47 hello I am using SQL Server 7, and would like to call a stored procedure from within a SELECT statement. something that would look like: SELECT Fld1, Fld2, MyStoredProc(Fld1, Fld2) AS Fld3 FROM Table1 is it possible to do it ? if yes, could you show me how, if no, is there some other method to do it without having to loop through all the records of the table ? thank you