call sp in function

Hello Ashok,

one way is to use xp_cmdshell to call a batch file where the batch file contains the exec proc statement. In the function you can call the extended proc.

eg.

But it is a good way of doing so. You can use CLR.

Link: http://stackoverflow.com/questions/1070871/how-to-call-a-stored-procedure-from-a-user-defined-function-in-sql-2000

For table type parameter you can created a type of Table and use it.