>Hi,
>
>The only way I found that I can assign a value selected in SQL Select to a variable as following:
>
>

>select @MyVar = (select MyColumn1 from MyTable where MyColumn2 = 'SomeValue')
>

>
>Is the above the only way to do it? Or there is a better approach? TIA.

Another way is

select @MyVar = MyColumn1 from myTable

The difference between these two methods is that the first will always change the @MyVar variable. In the second case, if the select statement does not produce rows, the original value of @MyVar will not change.