I've created a UDF to find the min of two integer values as
CREATE FUNCTION dbo.fnMinValue
(@ColumnA MONEY,
@ColumnB MONEY)
RETURNS MONEY
AS
BEGIN
RETURN (0.5 * ((@ColumnA + @ColumnB) - abs(@ColumnA - @ColumnB)))
END
and I'm calling this UDF in folloeing format
SELECT cast(dbo.fnMinValue ( @lcount,@Rcount) as int)
when i execute this in server it gives the following error
sham sumanPosted Aug 13, 2010, 8:07 AM
May be, this error is coming because what the fuction you have created is not available in your database. Check your dbo.fnMinValue function in below path of your database. Go to database-
Programmability - Function-Scalar-valued Function.
If the dbo.fnMinValue function is available you will not get this error.