Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Reply
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnMinValue", or the name is ambiguous
syed afroz
14 years ago
10.9k
Reply
Hi!
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
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnMinValue", or the name is ambiguous.
Plz help me out..
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Need help in database
Cannot open user default database