xxxxxxxxxx
BEGIN
ALTER TABLE IM_SOME_TABLE ADD NEWCOLUMN varchar(200);
DECLARE @CMD nvarchar(max) =
'UPDATE ST
SET ST.NEWCOLUMN = CT.NAME
FROM CITY CT
INNER JOIN IM_SOME_TABLE ST
ON ST.CITYID = CT.ID
WHERE CT.NAME IS NOT NULL
AND UPPER(CT.STATE) = '+ '''COLORADO' + '''';
EXEC sys.sp_executesql @CMD;
END;