Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_IntCalc", or the name is ambiguous

Question

This Error appear when I try to call the user-defined function

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_IntCalc", or the name is ambiguous

Here is the user-defined function:

CREATE FUNCTION dbo.fn_IntCalc (@IntersetRate NUMERIC(6, 3) = 10,
                                @Amount       NUMERIC(18, 5),
                                @FromDate     DATE,
                                @ToDate       DATE)
RETURNS NUMERIC(18, 5)
WITH EXECUTE AS CALLER
AS
  BEGIN
      DECLARE @IntCalculated NUMERIC(18, 5)

      SELECT @IntCalculated = @Amount * ( ( @IntersetRate / 100.0 ) 
             * ( DATEDIFF(d, @FromDate, @ToDate) / 365.0 ) )

      RETURN ( ISNULL(@IntCalculated, 0) )
  END

GO

And The calling part is:

SELECT dbo.fn_IntCalc(DEFAULT,2000,'Mar 1 2008','Mar 10 2008')

Do you get this when executing or just intellisense in SSMS? — Martin Smith, Mar 23 '15 at 19:04
Did you create the function with the same credentials that you are using to execute it? (Perhaps this is a permissions problem.) — DeadZone, Mar 23 '15 at 19:06
You should probably [rewrite this as an inline TVF anyway](http://blog.falafel.com/improve-performance-of-t-sql-user-defined-functions-by-converting-scalar-ones-to-table-valued-ones/) as scalar UDFs are notoriously bad for performance. — Martin Smith, Mar 23 '15 at 19:07
did you mean that the USE 'database name' should be used in the query editor?? — Ibrahim, Mar 23 '15 at 19:14
@Ibrahim - Either that or the selected database in the drop down must be the same as the database with the function (and the script has no `use` statements that change it) — Martin Smith, Mar 23 '15 at 19:18
@MartinSmith - I tried to set the USE statement in the query editor and that works now ,,, thanks — Ibrahim, Mar 23 '15 at 19:22

score 1 · Answer 1 · edited May 08 '17 at 14:25

1

Please try

SELECT * FROM dbo.fn_IntCalc(DEFAULT,2000,'Mar 1 2008','Mar 10 2008')

Hope it helps

edited May 08 '17 at 14:25

Andre Figueiredo

12,930
8
48
74

answered Aug 03 '15 at 03:14

John Smith

11
4

score 0 · Answer 2 · edited May 23 '17 at 11:47

0

These answers may be useful, take a look at them:

Cannot find either column “dbo” or the user-defined function or aggregate “dbo.FN_Split”, or the name is ambiguous
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.Splitfn", or the name is ambiguous

edited May 23 '17 at 11:47

Community

1
1

answered Apr 22 '15 at 13:01

Shashikant Mitkari

307
1
2
12

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_IntCalc", or the name is ambiguous

2 Answers2