Hmmm.... the code is NOT exactly the same... you added .Txt to the file name and messed up on some spacing (ie. BCP SET came out as BCPSET in your...

DOD eh?  Haven't they heard of ISO standards for data?  Sheesh!  Where's Joe Celko when you need a good rant from him?   ...

Thanks Mita... I learn something new everytime I do something like this, so thanks for posting the problem.

Lemme know how long it takes to do the 14 million rows... I'm...

I'll try running the code you posted back when I get home from work, tonight.  Looks identical... dunno by more than casual glance why you are getting the BCP error...

I never ask that question because the answer is usually something that raises my hackles

It's usually ok for Developers to have read...

Ok... now I get to accuse you of reading minds...   My only distain for that is if you are comparing two or more...

It's too bad that functions don't work like sprocs do when it comes to defaulting inputs so that we could make this function a little wider without having to insert...

Yep... could be done that way and, as usual, is very easy and yet creative on your part.  I was thinking something similar but I was really intrigued by the math...

 Ok... here 'tis... should be at least 30 times faster because it only produces the internal rows it needs for the...

Almost done... hang in there...

Never mind Well, duh!!!