If tempdb is growing well beyond what you think it should, check the code for Cursors and improper use of temp tables.

How big is your tempDB MDF getting?

Ah... I see...

Part of the problem is that both DELETE's and INSERTS are logged so you seem to have a lot of unnecessary logging.  The use of TRUNCATE would be...

Cool... thanks for the feedback, Jim.

Dunno... could be anything... can you post the INSERT and DELETE code?

You're missing the point, Uzwa... From the data examples you have in the first post, what do you want the output to look like?

Karthik,

Now THAT's a horse of a different color!   The example you posted is for "Flow Control" and there's not much you can do...

Karthik,

Yes... as David suggested, RDBMS's are designed for "set based" use.  It's the nature of the beast.  By definition, each column should only contain one type of attribute (LastName, for...

What I was getting at is if the source is from a GUI, you must have 3 fields... 1 each for Month, Day, and Year and each field must have...

Are the database properties setup to automatically shrink the database?

Bill,

Is this full time or not?  What are the terms of employment?  Any chance of telecommute?  And, without giving up the ghost, what discipline is the company... banking, telecom, or...

I'm just going to hazard a guess and say that no one has been able to figure out your requirements... Any chance of...

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???