SQL question - Cursor or not?
Posted
by grady
on Stack Overflow
See other posts from Stack Overflow
or by grady
Published on 2010-06-01T07:26:05Z
Indexed on
2010/06/01
7:33 UTC
Read the original article
Hit count: 170
Hi, I have a query which returns 2+ rows. In those results is a column which we can call columnX for now. Lets look at those example results:
columnX
100
86
85
70
null
null
I get 6 rows for example, some of them are null, some of them are not null. Now I want to go through those results and stop as soon as I find a row which is <> null. How can I do that?
Thanks in advance :-)
© Stack Overflow or respective owner