SPAM-HIGH: RE: [thelist] dynamic table sql question

[Joshua Olson]

> -----Original Message-----
> From: Peter  Brunone (EasyListBox.com)
> Sent: Monday, April 25, 2005 10:21 PM
> 
> 
> 	Er... Actually, I *did* mean update.  I was proposing an
> approach whereby he would build an update query (in a loop, 
> on the fly)
> for each table, rather than making a giant 15,000-character 
> union query
> that merely selects the values and still requires someone to manually
> update the tables in question.

My apologies!  His original post was about selecting records, and knowing
that the answer would almost definitely include a UNION given the table
structure (horrifying as it may be, it's what he's got!), I made a faulty
presumption.  In your answer, switching that one word from UPDATE to UNION
still made perfect sense, so I figured I was onto something... oh well.  

:-)

<><><><><><><><><><>
Joshua L. Olson
WAE Tech Inc.
http://www.waetech.com/
Phone: 706.210.0168 

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/