By the way, Giordy, don't you have some code to write to actually back you up?

Of course it is 1/8 of 8 apples. We're discussing quantities, not weight or volume.

If I have 7 little Winesaps and 1 big honkin' Red Delicious, each one is still...

Sohil, I'm not sure if I could easily walk you through job creation without posting a bunch of screenshots, etc., so I'll show you where to look. In SQL Server...

Okay, it's getting fun again, but I do have to admit an earlier error on my part.

When I claimed that Sergiy was too smart to actually believe the stuff he was...

Okay, I'd create a staging table to hold the data from the text file, and for safekeeping, I'd also make a copy of the table you're working with, in case...

Now that we have more details, a few more questions.

What data in the text file joins to the data in the table so that you can update appropriately? Alternatively, you...

A staging table is typically used as a temporary placeholder for data, often from some source other than SQL Server.

The idea is that you truncate the staging table and reload...

In that case, I'd recommend a staging table. Use that to perform the update.

It's probably not the answer you were hoping for, but we ended up having to handle the aggregate columns in the stored proc behind the dataset when we wanted multiple...

Sohil, did setting the column sort order to 0 not work for you?

I'm still not seeing why it wouldn't work, but you haven't give us much to work with here in the way of details. Since that system stored proc just sets properties,...

Short of upgrading to 2005, the typical method (even MS uses it for storing stored procs, for example), is to split the data into more than 1 row, with some...

Jeff, we can't have a thread this long without pie, so have some pie.

"So from a million, 50,000 are rounded up with ConvergentRounding, where as 100,000 are with traditional?"

David,

Your numbers are off because you compared the two rounding methods, not the rounding...

I'm happy to report that I have been using this product for several weeks now, and have yet to be arrested. It's too bad actually, as I could use a...