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

Joshua Olson joshua at
Tue Apr 26 02:47:52 CDT 2005

> -----Original Message-----
> From: Peter  Brunone (
> 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.
Phone: 706.210.0168 

Monitor bandwidth usage on IIS6 in real-time:

More information about the thelist mailing list