SPAM-HIGH: RE: [thelist] dynamic table sql question
Ken Schaefer
Ken at adOpenStatic.com
Tue Apr 26 01:59:09 CDT 2005
I agree entirely with Peter :-)
Either I "don't get it", or the database design isn't particularly conducive
to getting data back out (which generally means it's not normalised, which
generally means bad design).
Cheers
Ken
--
www.adOpenStatic.com/cs/blogs/ken/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: thelist-bounces at lists.evolt.org [mailto:thelist-
: bounces at lists.evolt.org] On Behalf Of Peter Brunone (EasyListBox.com)
: Subject: RE: SPAM-HIGH: RE: [thelist] dynamic table sql question
:
:
: 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.
:
: And just for the record -- although perhaps, as Brian suggested,
: I just don't get it -- this database design still doesn't seem like the
: best approach. I'm waiting for Ken Schaefer to either back me up or
: slam dunk me here, since I'm sure he's just about past his morning
: emails by now :)
:
: Cheers,
:
: Peter
:
: -----Original Message-----
: From: thelist-bounces at lists.evolt.org On Behalf Of Joshua Olson
:
: > -----Original Message-----
: > From: Brian Cummiskey
: > Sent: Monday, April 25, 2005 4:57 PM
:
: > Perhaps I need some sample data to get this together a little
: > better. I don't think anyone is really grasping what i'm
: > dealing with.
:
: If that ain't a conversation ender, I'm not sure what is. :-)
:
: Regardless, you'll still want a UNION, and you may want to look at
: creating the SQL for the UNION dynamically within a stored procedure,
: just as myself and Peter (except he accidentally used the word UPDATE
: instead of UNION) have suggested.
:
: Assuming you are describing your problem correctly, this will work, and
: may be the single easiest way to accomplish this task.
:
: <><><><><><><><><><>
: 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/
:
:
:
: --
:
: * * Please support the community that supports you. * *
: http://evolt.org/help_support_evolt/
:
: For unsubscribe and other options, including the Tip Harvester
: and archives of thelist go to: http://lists.evolt.org
: Workers of the Web, evolt !
More information about the thelist
mailing list