basically, if i UNION each select statement with node numbers [1],[2]....etc i get the desired results.

but as i said, i want to pass the node number as a variable on the run.

the reason is i am not sure. in each file how many SPECIALEVENTS we are going to get.

so, my plan is to first sum the SPECIALEVENT/TYPE1 and pass the sum value to a variable then run the procedure by looping only those many number of times to the 'SUM' value.

i can only achieve this by parameterizing the node number(singleton).

🙂