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               |
|
|----------------------------------+------------------------------------
--|





______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to