I simply want to do this in a stored procedure:

If @myValue = 1
    Select Field1 From myTable
Else
If @myValue = 2
    Select Field1, Field2 From myTable

In query analyzer I get the right select statement, but in dotnet or access
I get only the first select statement, unless I change it to this:

If @myValue = 1
    Select Field1 From myTable
    Return
Else
If @myValue = 2
    Select Field1, Field2 From myTable
    Return

Now adding the returns made this work, but I am not sure why.  Any solid way
to do this?

Derek

Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
JOIN Question...
create a sp from query output
Combine records to calculate