I have to ask, why?

>When I try the following test, I get error (below the expression)
>

>Declare MyVar decimal (12,2)
>Select Field1, @MyVar = num_field from MyTable
>

>
>that "A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations."
>
>Is there a way to still retrieve data and set a value to a variable?
>
>TIA