python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
snowflake UDTF update array at specific index
i'm very new to JS especially in snowflake and i am trying to achieve a very simple thing - i would like to update an array according to an index for each row.
this is my code:
CREATE TABLE T1(C1 INT)...
pawelek69420
Votes: 0
Answers: 1
Snowflake table and generator functions does not give expected result
I tried to create a simple SQL to track query_history usage, but got into trouble when creating my timeslots using the table and generator functions (the CTE named x below).
I got no results at all wh...
whetstone
Votes: 0
Answers: 1
AnyLogic: Is it possibile to multiple/sum/subtract/...respectively link two TableFunctions in AnyLogic?
I have two TableFunctions f1: arguments1 -> values1 and f2: arguments2 -> values2 given via their arguments[] and values[] arrays. I want to link them to a new TableFunction g, so that:
The argu...
DynamiX
Votes: 0
Answers: 1
How to return thousands of ids from a function accepting input to a select query
Create or replace function f(v_input nvarchar2)
Return t_table
Is
v_table t_table;
BEGIN
Select id bulk collect into v_table from table1 where "USER"=v_input ;
Return v_table;
End;
/
Sele...
Xyz
Votes: 0
Answers: 2