OpenQuery

[nelco]

I want to insert into a temp table on My-SQL db from SQL server db. Any idea on how to do it?

I tried the following but I get a syntax error.

INSERT INTO OPENQUERY(MetaQuotes, 'SELECT cAccount FROM MetaQuotes_VelocityLive.#A') select cAccount From #A1 Where dLastLogon = '01/01/1900'

 

[ousoonerjoe]

Have you tried something like the following?

SELECT cAccount 
INTO MetaQuotes_VelocityLive.#A1
FROM MetaQuotes_VelocityLive.#A
WHERE dLastLogon = '01/01/1900'

--------------------------------------------------
"...and did we give up when the Germans bombed Pearl Harbor? NO!"

"Don't stop him. He's roll'n."
--------------------------------------------------