Home Forums SQL Server 2005 SQL Server Newbies UPDATE table2 with value from table1 on INSERT into table1 RE: UPDATE table2 with value from table1 on INSERT into table1
SQLZ
SSChampion
Points: 12872
More actions
August 26, 2009 at 12:01 pm
#1045058
Try this:
INSERT into tbl_Assembly_Delay(ID, Code, DelayTime)
SELECT ID, '#Trim(FORM.Code)#', '#Trim(FORM.DelayTime)#'
FROM tbl_Assembly_Production
WHERE tbl_Assembly_Production.WorkOrder = '#FORM.WorkOrder#' ;
Karlsource control for SQL Server