how to execute stored procedure in a function using sql server 2000

[developerit]

hi iam using sql server 2000 i want to execute stored procedure in a function and the same function i want to call in view. can you give example which helps me

[The Digital Worm]

developerit wrote:

i want to execute stored procedure in a function

This is not possible by design, but you can convert the stored procedure in a function and then call it from another function or stored procedure.

developerit wrote:

and the same function i want to call in view.

Not at all possible, View is a mare logical representation of a select statement over tables/ other views. An in line table-valued function can perform as a parametrized view and you can call that in other functions/ stored procedures.

WJFK (Write Just for Kicks)