Search:

Type: Posts; User: Zesima29

Search: Search took 0.01 seconds; generated 36 minute(s) ago.

  1. I'm trying to find support for the OVER Clause in...

    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?
  2. Replies
    1
    Views
    3,029

    Previous row values in SQL

    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...
  3. Replies
    1
    Views
    4,336

    Issues using the SUM function in SQL

    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...
  4. Okay since the IF statements where not working, I...

    Okay since the IF statements where not working, I moved to WHERE statements where I can filter the values.
  5. I did it I was able to refer to the subcatchments...

    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...
  6. fields may not be used in IF, ELSEIF or WHILE Clauses

    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...
  7. How can I save it in the user number 1 from the...

    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...
Results 1 to 7 of 7