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

by

It’s a table-valued function, but you’re using it as a scalar function.

Try:

where Emp_Id IN (SELECT i.items FROM dbo.Splitfn(@Id,',') AS i)

But… also consider changing your function into an inline TVF, as it’ll perform better.

More Related Contents:

  1. Does query plan optimizer works well with joined/filtered table-valued functions?
  2. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  3. Check if table exists in SQL Server
  4. Sql Server string to date conversion
  5. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  6. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  7. Parameter Sniffing (or Spoofing) in SQL Server
  8. How to get Time from DateTime format in SQL?
  9. SQL Server String or binary data would be truncated
  10. Datatype for storing ip address in SQL Server
  11. How to change identity column values programmatically?
  12. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  13. How much size “Null” value takes in SQL Server
  14. best way to convert and validate a date string
  15. SQL Server ORDER BY date and nulls last
  16. How to remove accents and all chars a..z in sql-server?
  17. Find non-ASCII characters in varchar columns using SQL Server
  18. WHERE clause on SQL Server “Text” data type
  19. SQL Server error on update command – “A severe error occurred on the current command”
  20. Aggregate bitwise-OR in a subquery
  21. SQL server schema and default schema
  22. how to write number to word function in sql server [closed]
  23. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  24. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  25. FOR XML PATH(”): Escaping “special” characters
  26. What are row, page and table locks? And when they are acquired?
  27. @@ERROR and/or TRY – CATCH
  28. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  29. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  30. Random record from a database table (T-SQL)

Leave a Comment