Currently in Spotfire Professional Client through Information Designer , SQL Server User table functions doesn't work.
User wants Spotfire the ability to use SQL Server User table functions from information deisgner.
User created below function , but when user is trying to use this in Procedure in information designer , user is getting below error:
Failed to execute query: [tibcosoftwareinc][SQLServer JDBC Driver][SQLServer]The request for procedure 'fn_HelloWorld' failed because 'fn_HelloWorld' is a table valued function object
CREATE FUNCTION fn_HelloWorld ()
RETURNS TABLE
AS
RETURN
( SELECT 'Hello World' as HelloWorld)
User stated that there is lot of benefits of using functions. Specially for performance reasons.