Insert Select data from another table
Posted: Tue Mar 21, 2017 2:55 am
Please help identifying the error resulting : Incorrect syntax near the keyword 'SELECT'. Incorrect syntax near ')'.
Code in my Page_Render server event:
string sInsertSql = "INSERT INTO Monthly (PeriodID,EmployeeID,Salary) Values (99,99,"+" SELECT Salary FROM Employees WHERE EmployeeID = 2 "+" ) ";
ew_Execute(sInsertSql);