Hello Stephan,

I am unsure if K2 integrates directly with those. I know that temp tables and the like are not supported by K2 as smartobjects, but you can use Stored Procs to pull back data from multiple sources. 

Hi,

I'm not sure if this is going to be possible without building a SQL procedure to call the function(s) since these are not really SQL objects that K2 can see.

https://stackoverflow.com/questions/33449/can-you-call-a-webservice-from-tsql-code

Hi,

i see the necessity to clarify my question.

I am not talking about CLR Functions. I am talking about normal sql functions:

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-function-transact-sql

They are internal sql objects that are accessible like procudures, type IF, TF, FN, see example query below.

One uses functions because you can combine tables and functions with JOIN clauses. This not possible with Stored Procedures.

Kind regards,

Stephan

SELECT type_desc, type, COUNT(*)
FROM sys.objects
GROUP BY type_desc, type
ORDER BY COUNT(*) DESC