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 !