Thanks to both of you! My actual scenario is more complex, with joined tables even on the inside loop. What I gather from both of your examples is...

Thanks for the tip don1941. I'll try it out tomorrow at work.

As soon as I hit 'post' I realized that this example is too simple. I can simply substitute 'MIN' where 'FIRST' is used.

I also figured out that this is...

Thanks don1941,

I did end up using Bulk Insert for my data needs. I have delimited files which are quite clean. I can import them directly into a temp...

'one file in particular that breaks out into 9 different row types'...Now THAT sounds ugly!

Some questions/comments:

Was there a compelling reason to choose bcp over bulk insert? As I'm using...

RE: Import and transformations.

My database is fairly lightweight. I receive 2 monthly files @20MB and about 12 weekly files @350MB only. The monthly files are appended to existing...

Cathan (Scorpion_66), I was started down the trail of using your exec examples, but it didn't seem to work for me to build the SQL statement and store it in...

Thanks for the quick reply Phill. Works like a charm.

I can't seem to substitute an input variable for a string in the bulk insert code below. Any ideas? (Error just states 'Error 170: Line 12: Incorrect Syntax...

Thanks, Simon. It was a bit of a pain to create the file, but it works! imports 108000 rows/10Mb in under 7 seconds. I don't expect the...

Thanks, scorpion_66! I'll be trying the bcp method next.

As I'm a relative SQL newbie, I'm doing this same project several ways and comparing results. I just did the...

Thanks for the quick reply and, yes, I would be interested to see the script library.