>I need to do something like the following in a query.
>
>

>
>DO WHILE looping through fetched rows and @MyVar changes value
>
>BEGIN
>
>IF @MyVar = 1
>     BEGIN
>          Do This
>     END
>
>IF @MyVar > 1
>     BEGIN
>          Do This
>     END
>
>IF @MyVar = 1 and there were no @MyVar > 1
>     BEGIN
>          Do This
>     END
>
>END
>

Edit: I read your question incorrectly.