I have a table variable called @Results with a bunch of data in it. One of the columns is called Info.
I'm trying to update the data in this column using the following:
Set Info =
CASE WHEN [@Results].Info = 'Other (Please explain)'
('Other - ' + SELECT InformationTrackings.OtherInformation FROM InformationTrackings
WHERE InformationTrackings.TrackingId = [@Results].Id)
This seems to work OK if I leave off the SELECT part of the statement, and just have 'Other-'. But when I add the SELECT part it doesn't seem to be the correct syntax.