Thank you to all for replying. Your responses have been extremely helpful! It's given me enough to work with.

.mf

Hi ck2,

If I were to use a Bulk Insert, using the link you provided as an example. The .csv is in an excel file, what would the values be...

Hi Luis, that works, thank you,

Thank you for the explanation Gila 🙂

Thant really helps and clears my confusion, I'll use your suggestion.

Thanks Lynne!

if there were multiple columns would I...

Thank you for the explanation Sean.

Oh yeah, brackets! Thank you Lowell.

Thank you for the quick replies SSCrazy and Mr or Mrs ...

Hi vyas, thank you for the reply. That's the same syntax that I originally had, or at least I can't see the difference in your query, am I missing...

Thanks sdvoranchik,

I just found something similar here: http://technet.microsoft.com/en-us/library/bb630430.aspx

I am working with my server admin to do this, and will post if it works.

Hi Lowell, your second solution worked well. I never really understood how to use coalesce or how it would come in handy in a practical situation until now, so...

Hi opc.three thank you for your reply, your suggestion makes sense and makes it simpler. As a learning excercise if I were to use dynamic sql how would this...

Wow...fantastic answer. Thanks so much Gila.

Ok...so if I run the query using 'not in' instead of 'not exists' it produces the desired result of 'xyz', what is the difference between the two methods?

with cte1 as

(

select...

LOL...sad to say...it's pretty much whatever gets the job done in the fastest time possible.