In SQL Server, it’s possible to insert into a table using a SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql. Craig S. Mullins Database Performance Management: Return to Home Page. August 1999 : Using CASE Expressions. by Craig S. Mullins If all of the devices in the system can communicate with an OPC server, that may be a solution to investigate. operations…