Rathi

It may not help performance, but it would simplify your query if you removed those subqueries and joined directly to the tables, and if you get rid of the CASE...

Please will you explain what your whole package is doing? I don't think the OLE DB Command is the right component to use. It belongs in a data...

Deliberate error. I'll let you work it out!

John

Run this while the delete is taking place:SELECT wait_duration_ms, wait_type

FROM sys.dm_os_waiting tasks

WHERE session_id = <SPID-of-connection-doing-the-delete>

What do you get?

John

You could remove the "- " and put an "01 " at the beginning. You'd then be able to cast it as date, subject to your local language settings,...

I don't think you need to use WITH RESULTS SETS. There is no result set. You could use WITH RESULT SETS NONE if you wanted, but I can't...

Paolo

We haven't seen Jeff's solution yet, but my guess is that's going to be the way to go if you don't want to modify the software. If you do...

RESTORE is a SQL command, not a command shell command. Use [font="Courier New"]EXEC (@sqlcmd)[/font] instead. And don't forget to escape those enclosed quotes by doubling them up.

John

As I suspected, then, the.mof extension is not recognised as that of an executable file. You'll need to find a program to open the file with.

John

WITH Rates AS (

SELECT

currency

, AVG(b.exch_rate) AS avg_rate

FROM uviexchrates b

WHERE date_from >'2015-01-01' AND date_from < '2015-12-31'...

Try these commands, one at a time in the same order:c:

cdcd "Program Files"

cd "Microsoft SQL Server"

cd 110

cd Shared

sqlmgmproviderxpsp2up.mof

John

Apologies, I missed an important word out of my last post:

John

In that case, I would guess either that sqlmgmproviderxpsp2up.mof doesn't exist in the location specified, or that the.mof extension is recognised as that of an executable file.

John

Try this:"C:\Program Files\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsp2up.mof"

John

Have you considered replication?

John