Just about perfect... I'll be back in a few...

Look at it this way... they're all flaming one thread and leaving the others alone

That's referred to as a "sequence table" and it one of the things that was suggested.  But, you must be VERY careful how you do the update to it or...

Can you get them to reverse the process?  Seems to me that the data table should be there completely befor the trigger table that says it is.

You're welcome...

Not sure what it is but being called "dear" instead of "Jeff" kinda bugs me, especially if you're a guy... must be a language barrier thing

So... post the actual name of the column that identifies individuals along with a bit of sample data for those, the actual names of the other two columns, the datatypes...

<Psssst!  Bulk Insert...>

BULK INSERT dbname.dbowner.tablename  

FROM '\\machinename\path\Sample.csv'

   WITH

      (

         FIELDTERMINATOR = ',',

         ROWTERMINATOR   = '\n',

         FIRSTROW        = 2,

         ROWS_PER_BATCH  = 50000 

      )

No need for format files or anything else...

PLEASE, don't double post...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=380596

Lookup "Expanding Hierarchies" in Books Online.

And, if you search this site for "Hierarchy", you'll also find some pretty decent procs/functions for this.  If you come across any that use recurrsion,...

Heh... I think lots of folks, including me, have made that error at least once

Just a bit of an edge for performance...

You do NOT need a cursor to do this... but I need a bit more information...

1. Are you the only person who will store this type of data in the database?
2. Why...

Dave,

If you want to do this from an app or even TSQL itself, see the following script for how to do it... and, yes, it is a registry change...

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1854

I guess I just don't understand why you are using OpenRowSet when Bulk Insert will load the file in about two heart beats.  You wanna try that, instead?  Lemme know...

Could it be that the sender of the files is sending the trigger file before the data file is received in total?

Spot on, Michael