I am trying to "set" a variable to either 'Resolved' or 'Active'. I tried using an update case stmt but it would only return 'Resolved' when clearly there should have been some 'Active'.
This is the stmt I am using.
declare @status varchar(20)
Set @Status =
when field > 1 Then 'Resolved'
The field has a number from 1 to 10 in each of the records but @status just returns 'Resolved'.