UPDATE from SELECT using SQL Server In SQL Server, it's possible to insert into a table using a SELECT statement: INSERT INTO Table (col, col2, col3) SELECT col, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update via a SELECT? I have a temporary table containing the values, and would like to update another table using those values. Perhaps something like this: UPDATE Table SET col1, col2 SELECT col1, col2 FROM other_table WHERE sql = 'cool' WHERE Table.id = other_table.id Answer: UPDATE Table_A SET Table_A.col1

Select and Update in same time and gets displayed I have this query: SELECT MIN(id),CustomerName, Scenario,StepNo,InTransit,IsAlef,runNo,ResponseLength FROM `RequestInfo` WHERE `CustomerName` = 'Hotstar' AND `ResponseContentType` like '%video/MP2T%' AND `RequestHttpRequest` like '%segment%' ; which gives me output like this:- +---------+--------------+----------+--------+-----------+--------+-------+----------------+----------+ | MIN(id) | CustomerName | Scenario | StepNo | InTransit | IsAlef | runNo | ResponseLength | IsActive | +---------+--------------+----------+--------+-----------+--------+-------+----------------+----------+ | 139 | HotStar | SearchTv | 1 | No | No | 1 | 410098 | NULL | +---------+--------------+----------+--------+-----------+--------+-------+----------------+----------+ I want to insert string