ACTSQLVAR: [Microsoft][ODBC SQL Server Driver]Query timeout expired -2147217871 0 Microsoft OLE DB Provider for ODBC Drivers at shortdetails SQL is ;WITH MySource as (
SELECT ScriptEcho, ScriptMilliSeconds
FROM (VALUES ('findlanguages.prx?id=nl&which=byCountryAndYear&year=1997','3812' ) )
AS TempTable(ScriptEcho, ScriptMilliSeconds)
)
MERGE tblScriptEcho AS MyTarget
USING MySource
ON MySource.ScriptEcho = MyTarget.ScriptEcho
WHEN MATCHED AND MySource.ScriptMilliseconds > MyTarget.ScriptMilliseconds THEN
UPDATE SET
ScriptMilliSeconds = MySource.ScriptMilliSeconds
WHEN NOT MATCHED THEN
INSERT
(
ScriptEcho,
ScriptMilliSeconds
)
VALUES (
MySource.ScriptEcho,
MySource.ScriptMilliSeconds
);