While selecting the rows from the table I used a With NoLOCK option and it started working. Seems the select had set a lock on the table. Will using a...

Is there any workaround for the blockage due to update, not allowing any insert.

There is a merge join that filters out rows to update and insert; The update works fine and as soon as insert happens the rows dont get inserted and table...

Thnks for the response.

Actually I did not want the hour diffrence, I wanted the time for which the employee was in? ie in this case from 12 to 3 the...

Thanks Elliot

The connection manager is dynamic. The columns are not same everytime.

Thanks. It worked

For that i will have to load the rows in Excel into a table.

I was asking if you can get the count directly using the Excel?

Can you please tell how it can be done?

the query returns only 288 rows and still the problem exists.

Any resolution to this problem if one of the numbers is a super large number ?

Thanks for the reply.

Just curious to know if there is any other method to filter out records that need to be Updated / Inserted other than using Merge Join