I re-booted yesterday and everything is working again .

Thanks

Billy

Yes, Outlook is the MAPI client [MS Exchange Settings] and I can access and send email with same user that SQLAgent uses [tried both domain/administrator and domain/sqlexecutive].

Here's an active x script file I use:

Function Main()
Dim tMain
tMain = DTSTaskExecResult_Success
  If isCurrentFile("FLATFILE.TXT") Then
    tMain = DTSTaskExecResult_Success
  Else
    tMain = DTSTaskExecResult_Failure
  End If
  Main = tMain
End Function
Function isCurrentFile(strPath, strFile)
   ...

Mark,

Thank you so very much for the simplification. I had tried a couple of different ways but had failed to add the additional operator in the ON portion.

I'm willing to use equi-joins. I'm just not sure how it would work in this problem. Wouldn't it still return results for the first record in the join?

Using your query,...

Thanks Jeff!

This query does work faster with both procedures. Alas the result is flawed as it was in my meagor attempts because it returns the sum...

I'm not sure why but I changed the query in both from

"... II.Stores = I.Stores..." to

"...II.StoreKey IN (SELECT StoreKey FROM StoreGroupMembers S WHERE S.StoreGroupID = @StoreGroupID)) AND (II.InvoiceDate = I.InvoiceDate)..."

As...

Execution plans may be viewed at:

http://www.afslr.com/ExecPlans/Default.htm

I am executing both stored procedures from SQL Query Analyzer at my work station connected to the LAN.

These procedures are on the production SQL...