fiogf49gjkf0d I am trying to update SIC Codes on the Account table with data provided by an outside source. I tried executing the following SQL statement in the SLX Administrator, but I get errors: Failed to parse SQL
UPDATE ACCOUNT
SET MODIFYDATE=GETDATE(),
MODIFYUSER='Admin',
SICCODE = L.SICCODE
from ACCOUNT A, LoadTable L
where A.ACCOUNTID = L.ACCOUNTID
This query works fine in SQL Server Query Analyzer, but I need the changes to be synched down to
the remote databases, so I need to run them in the SLX Admin. I am on SLX ver 7.5.2. Any suggestions?
|