SQL is a set-operating tool, not a row-by-row processor, so it can take only one pass.
Was gonna suggest case, but I see you looked for that. That's a more advanced SQL, so your tool might be very old and basic.
OTOH, I do have an Excel spreadsheet that has serious nested calculations going on - hideous. I have to copy the thing into Word to edit it, then paste it back. Without all the formatting I used in Word to make it readable.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
timeasmymeasure
no subject
Date: 2014-11-15 03:03 am (UTC)SQL is a set-operating tool, not a row-by-row processor, so it can take only one pass.
Was gonna suggest case, but I see you looked for that. That's a more advanced SQL, so your tool might be very old and basic.
OTOH, I do have an Excel spreadsheet that has serious nested calculations going on - hideous. I have to copy the thing into Word to edit it, then paste it back. Without all the formatting I used in Word to make it readable.
So I feel your pain.