Wouldn't you want to put those repeating records in a child table from a design point of view?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 9:56 AM To: SQL Subject: RE: SQL HELP That's exactly the scenario the articles address. |------------------+------------------------------------------------------| |Eric A. Laney |Nothing can be both completely general and internally | |Systems Architect |consistent at the same time. | |Verizon Security | | |Voice: | | |813.293.3093 | Sweer's Impossibility Theorem| |Pager: | | |888.551.3718 | | |------------------+------------------------------------------------------| "Mohammad Mansour" To: SQL <[EMAIL PROTECTED]> <mmansour@hwwils cc: on.com> Subject: RE: SQL HELP 02/08/2002 09:20 AM Please respond to sql Thanks, I will check out the site, but the data is not coming out of a csv file, its already been formatted and now exist in another SQL table. It basically comes down to breaking one record from one table, to as many duplicate records to another table, except for the product field, depending on how many products exist in the field. So if there is one record with five products in table one, once exported to table two, it will be 5 records, with one product for each record. Thanks for your help. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 1:48 PM To: SQL Subject: Re: SQL HELP I recommend that you check out http://www.sqlteam.com/ and look at the articles on using CSV data. If you substitute a space for the comma as your delimiter, you should be all set. |----------------------------------+------------------------------------ --| |Eric A. Laney |Don't use no double negatives. | |Systems Architect | | |Verizon Security | | |Voice: 813.293.3093 | Another English Lesson| |Pager: 888.551.3718 | | |----------------------------------+------------------------------------ --| ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
