I have not clearly defined my question and the parameters of what I am after.

The failure is mine, to be able have others be able to help, one must clearly...

Yes, the SQL is correct, but the logic is not producing the desired result.

EmpID 2 ALog 4 1/1/2008 - 4/30/2008 0.33

EmpID 2 ALog 8 ...

Chris, Thank you for taking the time to review this issue.

Your SQL is correct for the EmpID 2 with only Alogs 4 through 8.

But when I uncomment the code and...

Here is a solution written by Peso... original post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110508">

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110508

DECLARE@Sample TABLE

(

aLog INT,

aBegin DATETIME,

aEnd DATETIME,

EmpID INT,

aPercent SMALLMONEY

)

INSERT@Sample

SELECT1, '03/08/2008', '03/31/2008', 1, 0.6 UNION ALL

SELECT2, '03/08/2008', '04/04/2008', 1, 0.4 UNION...

I have discovered that the above SQL fails if an additional activity log for EmpID 2 from 2008-04-01 to 2008-04-30 at 68% is added.

The above SQL (with the data set...

I have the solution to my isuue.

The complete thread can be found here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110508">

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110508

You can't have both logic into same query!

Either use this logic

For EmpID 1

ALog 1 overlaps...

Thank you for your response,

Yes, I was previously using

Delete From GME_Resident_Errors_v

Deleting everthing by using my the view that I had set up.

I replaced it with the TRUNCATE table command in...

Just as an update to this topic. I completeley removed the Access VBA code and pass through query that was failing to execute to a new database. The code ran...

Thank you for your response and the links on how to properly post!

Jack wrote:

What events are you profiling? I would check the locks and lock timeouts and blocking. ...

Thank you for your response.

I created the Pass through with the returns records set to No, but just to be sure I have added the following to my code:

...