What is the current table definition? Maybe there's a valid natural key in there.

You need to add the where condition in the exists clause.

select q.m_date, q.mday_num

from qvi_app.dbo.mcal q

where not exists

(select * from view_app.dbo.mcal i WHERE q.m_date = i.m_date and q.mday_num =...

One thing I quite obviously found is that even if the query runs in seconds, it can take minutes... hours to render the report.

It's quite easy to spot, if you...

LAMOROTF, can't wait to see that on youtube :D.

I'm a bit curious here (never used SSIS). So you are saying that this sort transform basically only keeps 1 row PER manager. Can you decide which row...

Doesn't that make 24 e-mails a day anyways? :w00t:

This of course assumes that you are using sql 2005.

Sorry to go this basic... but if you made a tiny posting error and are using sql 2000, you...

That sounds about right (I'm just no expert there), but sleeping seems like "done doing my batch" to me.

I see what you are going through. But on the other...

Thanks, but I meant the query you are using ;).

Create a table (like any other table). Make sure the name is significant like Staging_Managers.

The insert all the data in that table. (Make sure you truncate before the...

It's basically the same answer as I want to restore without a backup... you're screwed my friends. Learn and move on.

Now would be a good time to learn to...

Please post the actual code, it's eaiser for us to help that way.

What login are you using?

Does that login have permissions on all DBs?

Well step 1 in any etl is EXTRACT.

So I'd put all that data into temp table then I'd start the transform tasks. Then my query would easily work.

Back to the basics... why is this causing you a problem? Are you having blocking issues, running out of ram?

If you just have many sleeping connections and no other...