Thanks guys.

This has helped. But that would mean to look at other things for my performance issue.

OK.

Now it says -

Cannot convert between unicode and non-unicode string data types

It was an invalid column name for IPEquipmentID

One of the joins had a problem.

I was joining it with the column which did not exist for that table.

Sorry, its probably the Monday that's the cause of this stupid...

Gail,

This is an SP for some reports for which the users just want rough numbers and accuracy is not the highlight.

Also, there is loads of data and users working...

OK. I know about the connection manager now.

However in a Execute SQL Task; I want to delete rows from a table in the Access database for which the Jet ole...

I just realized that. 🙂

Thanks for the help.

But I had heard Left joins are slow too. Plus with NULL checks I thought it would be even slower.

Are these OR's even worse?

Yes, if you could please.

Well then, the alternative would be to use the Condition checks on NULL in the where clause.

Is that alright?

Well, the OR does work. So I am going to use this -

select RowID

from dbo.Table1 a

inner join dbo.Table2 b on (a.RowID = b.RowID1 and b.TableID1 = 30) OR (a.RowID...

Well, it does.

I only wanted to retrieve those RowID's from Table1 which would have a match in Table2, irrespective of what columns it comes from.

And I dont want to check...

This would return the the details of the first Table with NULLS in the columns of the second table, if it does not match either rowID or tableID of the...

I guess you can use the OR. I just tried it on temp tables. 🙂

Thanks to both of you. This has really helped.

I think, the question really was whether bulk inserts happen one row at a time. And since the answer is NO,...