I just discovered that bcp is missing rows in the flat files when importing, ...

Ummm.... why don't you...

Rog Pike... where the hell are you now?

What's the source of information for the text file?  A GUI??? or ???  In other words, what puts the data into the text file?

You'd probably get more help if your output example matched the example inputs in your post... for example... where the heck did the "x", "y", and "z" come from???

See what I posted here... http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=395869

Then, as Steve suggested, post the code you want to convert (provided it's NOT hundreds of lines long)

The "key" to good, high performance "Set Based" code, is to forget everything you know about programming for row solutions.  Instead, think about what you want to do to an...

Never heard that, Eddie, but I'll be on the lookout for that from now on... one more chip taken from the language barrier.  Thanks.

You're welcome, Zia.  And thank you for taking the time to explain your duplicates.

Looks pretty familiar, huh?

Shamshad,

You forgot to include the offending code like I asked...

We had similar problems finding the CPR (cut, paste, replace) code liberally sprinkled in some of our apps.  It was a bit time consuming and certainly required some regression testing,...

I'm not sure why you have data duplicated in two separate tables... that usually constitutes a violation of 3rd Normal Form... but it's your database...

... something like this will do...

I've got to agree with David... I'm sick and tired of exams that have been written by folks that are simply not qualified to write exams.  That includes the things...

Any of your processes or stored procedures using Cursors, While loops, or other RBAR?

The problem is likely not the Dynamic SQL... nor is it likely the fact that you are joining 6 tables... but it's real hard to figure out what it could...