mandavli (1/6/2011)

---

I have written scalar function named getCalcvalue that accepts 2 parameters and returns one parameters.

Now I want to call this from stored procedure.

so I have statement

declare @selVal as integer

set @selVal = select getCalcvalue(param1,param2)

but I get error 'getCalcvalue' is not a recognized built-in function name.

So I tried

set @selVal = select dbo.getCalcvalue(param1,param2)

Then also I get error How do I call this fuction correctly