Would this help?

WAITFOR DELAY '00:00:00.05' -- Wait for 5 ms

And also if there are 6 threads spanning 70k records, will table partitioning be of help?

Thank you. Also - the plan changes when I use the same batch using sp_ExecuteSql

I see there are no Key Lookups when I run the same query using sp_executesql as...

The batch is big. Can you let me know how how I can check the performance benefits.

Thanks all for your help. I finally managed it using the same query that I had created.

This query was a part of an SSIS package.

We broadly categorized the conditions...

Apologies if I wasnt clear. I have been working on it since last night.

Have reached to some point but need help to proceed.

Please find additional rows in this table to...

Thanks however it may not always be the last one. The subtraction should happen between consecutive ones.

i.e Row 1- Row 2.

If Row 1 - Row 2 =0 then...

Thank you - this helps

Thats for your time... yes there was a reason to use Access as data manipulation which would be required later would be easier using queries.

I fixed my issue... by revamping...

Microsoft Office Access 2007 (12.0.6535.5005) SP2 MSO (12.0.6562.5003)

Further information on teh above.

1. The query does not have any group by clause.

2. The only manipulation with the memo field is the prefixing with text "Error:" when the description...

I have modified the complete code piece.

Now I have made tables in Access with field type Memo for Description column.

The query has been modifed too.

I need to compare descrioptions from...

Current issue:

-----------------

Yes I am usinig DoCmd to import the excel files into tables and to export query results into excel.

The table structure for import is not predefined.

For import:

DoCmd.TransferSpreadsheet...

I am using Excel 2007 and MS Access 2007.

I use DoCmd to import the data from 2Excel files into Access... and then compare the text and use Do Cmd to...

Thanks Jeff.. these are not the actual tables. We are getting two resultsets and want a solution thereafter. However, i do get your point. Cant help much at the moment...

Thanks for the response.

Sean:

In the current scenario - there is one set of records being populated in multiple related tables. There is only one set of records for a workflow...