call sp in function

Question

how can take output type parameter as a table in store procedure and use this sp inside function?

Dhirendra Misra · Answer

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. create function... exec master.sys.xp_cmpshell 'C:	est.bat' .... return... 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.