Eugene... wanna post some data from the file, please?

Guess you can't actually look into a book on Amazon anymore, huh

Ummm.... not quite that simple... need to distribute a batch of QTY 15 issues against 4 batches of QTY 5 each and do the calculation and forward the remainder.  Lot's...

That's why the stored proc method is better.

Thanks for the feedback, Kung Lao.

Is GROUP BY what you're looking for?

This sounds like the text version of a "name/value" table... I'm with MrPoleCat... if you could post a bit of the text table, perhaps we could help.

I don't know what sqlcomm1.ExecuteNonQuery() does because I'm no GUI programmer... UPDATE's are actually a form of a query and that may be your problem (but dunno for sure).  But...

Heh... and I just "assumed"... we all know what happens when you do that, eh

Well... that depends... do you want to shrink the file or not?  The NOTRUNCATE causes the "freed file space to be retained in the files".  If you want to actually...

Heh... not unless some fool thought it would be a good place to store permanent data

Sum of the quantities for a given part.  Quantity is add if the RowType is 'Receive', Quantity is subtracted if the RowType is 'Issue'.  Another name for 'RunningBalance' might be...

Haven't figured out the long term/shorterm things yet, but here's some more realistic data to play with... created a single "work" table just to help imagine what's being received and...

Heh... I think you're making a mistake using FLOAT on the RATEs (which I assume will be currency amounts of some sort).  If you don't think so, try this...

July 24, 2007 at 10:48 pm