Strommy (10/17/2007)

---

I'm not sure about the performance you will get out of this, but try using the following syntax:

Select ID1.*, BT.Name From IMPORTFILE_DeDuped1 as ID1

left outer join BIG250MMTABLE as BT

on...

Nope no nulls, we specifically remove those prior to the select.

can we see an example of the column that is getting imported and some that are not getting imported?

I would convert the excel doc to a tab delmited file and...

I personally would not do that, best approach would be to use specific parameters and construct your where clause in your proc. building adhoc sql outside of a stored procedure,...