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

Filed under:
|
|
|

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

Related posts about sql

Related posts about tsql