Comments by srinivaskalagara (Top 5 by date)

Thanks for your solution.But I didn't find solution to my problem. Your's helps obviously to refer .asmx extension files but how to do refer direct WSDL file that was provided by somebody who don't want to expose their mehods and parameters in the .asmx file.

I think my problem still not got resolved. As you said if we use Stored Procedure , how can we call this SP from Select statement scripted inside other stored Procedure and use return values.

My question is simple:
Select empid,empname,dbo.func_GetDepartment(@empid,@Depid) from emp;

We can get output directly with above script.

Select empid,empname,dbo.func_GetDepartment(@empid,'Depid') from emp;

if we pass column name 'DepId' the earlier said problem popping up.
How can we use Stored Procedure in this case to include anonymous values from other table without disturbing in the Master script.

Good article!! But Is it always good to go with Cursors. Looks like OpenQuery option is the better one. I think OpenQuery helps in callling SP inside function. Isn't it?

How can we use stored procedure inside a function?