Table function

Question

Hello everyone, 
 I have a question that table function is created in the database with set of columns and How will I use the table function in appian with some parameters? 
 Can anyone please help me to further proceed? 
 Thanks in advance.

Chris · Answer

If you want to obtain data from a Table-valued Function in your database, you can create a view that queries the function, and set a data type / data store up on the view, same way as you would for a normal table. 
 I do this in one scenario where a report is generated by a function that creates/returns a temporary table, ended up being better for performance this way in my scenario, where lots of data is aggregated for a weekly summary. 
 CREATE view [dbo].[VIEW_FROM_FUNCTION]
as

select 
[Col1],
[Col2]
/*etc*/
from dbo.fn_YOUR_TABLE_VALUED_FUNCTION()

GO

deepakg681722 · Answer

Please create primary key for a column for example, create a new column with name ID and makeit primary key.

Table function

Top Replies