Search:

I'm trying to find support for the OVER Clause in ICM SQL V8.5 but I didn't see anything related on the manual. Can someone please give me any tips on how to calculate running total?

I'm trying to use the previous value from a row to perform some calculation on the present row. On SQL we have the LAG and LEAD functions that let you use the previous and the next value. What do we...

I'm doing some computation with the population values of the subcatchments, and I'm trying to compute the cumulative values using SUM and then I store it in the user define column, but when I apply...

Okay since the IF statements where not working, I moved to WHERE statements where I can filter the values.

I did it I was able to refer to the subcatchments user columns by writing this.
UPDATE Subcatchment SET user_number_1 =
node.user_number_1, user_number_2 = node.user_number_2 WHERE...

I want to do some extra calculation to the population values of the subcatchments. I'm able to do it partially. I tweaked a sql code that I found and I can do some computation to the population of...

How can I save it in the user number 1 from the subcatchments

I modified the last couple line to this, but it still saves on the nodes' user number 1 column

SELECT SELECTED (population) INTO...