Absolutely agree... if the numbers table is large enough... if it's not, then you can do something like the following...

... Also, in 2k5, you really don't need a recursive CTE...

Thanks for the feedback, Phil. Really appreciate your comments.

By the way (almost forgot)... they haven't fixed the code windows on this forum, yet. If you just copy and...

Holtis,

That's a good question... what is the 1/1/1/20008 notation? Is it real or just a cut and paste error?

Certainly not... but I don't use DTS or SSIS for several reasons... wanna give it a try for us? Because I don't use it, I wouldn't know where to...

Nice.... just be a bit careful... haven't tested it but it looks like if the serial numbers are large, that'll take a while to resolve.

Yes... not only is it possible, but it's a frequent recommendation... just change the SET ROWCOUNT value to what you want in the code that follows... note that this is...

Wow... that's pretty rude... I just found your other 10 cross posts that you posted every 30 to 60 minutes.

This is a cross post...

http://www.sqlservercentral.com/Forums/Topic445746-145-1.aspx#bm446281

Those symptoms seem to match the symptoms in the KB article that VYas mentioned. Did you read the article?

We need to know what the current service pack...

Ok... thanks for the feedback, Lester.

Ok, thanks for the info. I'll see what I can do tonight after work.

Would you share your solution, please?

James,

Are you expecting the TestID to repeat, starting at 1, for each HeaderID in the test table?

Just add the column as a nullable column. Then populate it. When you're done, alter the column to be not null.

Bulk Insert can see the files on the user desktops if the server is logged into the domain with the correct privs.